Please read both word document and workbook for project details:
Develop Program/Script to extract product information from API Service
Our business would like to automate some processes with one of our suppliers, [login to view URL] who have an API service. The API service allows us to import and extract product information from their database.
Products in the database belong to 2 categories; with options and without options. For this project your main focus will be to develop to extract and import products WITH options
IMPORTANT: We already have an Excel VBA Script to extract and import products without options. We are happy to share the VBA with the developer if they wish to work from this.
1) Download a report from BG website for example rankings report. These reports will specify what products and categories to extract and download for the next steps.
2) Using BG API service generate/download product information based from the report in step 1. This must be exported to excel file. Other parameters of the product information include excluding products from a particular category/sub category, all products under a particular price, under a particular weight, exclude any products ID’s from a specified list, etc
3) Data cleanse the data product information from above step. This includes for example removing html tags, prices and certain words from the description fields, and adding/joining specified text to the product information. The final product information must be in a readable format with non-readable characters removed.
Requirements (include but not limited to):
• Script must extract all products WITH OPTIONS based from a report from BG website
• Script must allow parameter setting options to control what products are extracted
• Extracted product information must be cleaned with all HTML tags, specified words, removed and in a readable format with non-readable characters removed.
• Extracted information must include each product options individual SKU/POA number, price, stock amount, individual option image URL, main product image URL, product “package included” information.
• The process must finish running in a reasonable amount of time
Please refer to the uploaded API Service Criteria workbook for a more detailed requirements of this project
Minimum 8 milestones, To be confirmed later.
More details on their Banggood API service (if you wish to login to website and API service for more information)
[login to view URL]
BG Products Download Page & Login details:
[login to view URL]
user id – thegoodlife881@[login to view URL]
password – good2019
This project is only for stage 1 of a 5 stage full solution we would like to develop later.
However the winning developer in this project will also be consider and favoured as the leading developer for our future full solution projects below:
Stage 2 - API service upload orders and monitor tracking
Stage 3 - Development for Customer management system
Stage 4 - Full solution integration of all 3 systems
Stage 5 - Implement same system for our other contracted suppliers
With this in consideration please price competitively and provide some background on your experience and how you think you tackle this project. What will your solution look like?
We look forward to hearing from you.
7 freelancer đang chào giá trung bình $287 cho công việc này
I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]
Hello Joey, hope you are doing great. I read full descriptions of your project, and I feel this work good fit for my skill set. I have 5 years working experience in web development. please contact me. Thanks