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.
4 freelance font une offre moyenne de $219 pour ce travail
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Plus
Hi sir, I have dropped you message in chat and have been through this project description already. Please go through my messages and will discuss it to get done.
I have a strong background in Excel/VBA, including accessing information on the internet through API, and other methods as well. Passionate about creating programs that simple so that non-experts will have no problem u Plus
Customer's satisfaction is my goal *** *** Also 100% Completion is happy of me and client. *** *** Rest is my creative idea and honest effort. *** Looking to be your Good Venture along with your project! Best Plus