Đã Đóng

Develop Program/Script to extract product information from API Service

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.

Process Steps:

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

Milestone Payments:

Minimum 8 milestones, To be confirmed later.

Supporting Information:

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.

Kĩ năng: API, Excel Macros, Excel VBA, HTML5, Process Automation

Xem nhiều hơn: program need extract information screen, write script extract information website, program extract contact information yellowpages superpages, amazon scraping service, calling rest api from javascript example, amazon scraper python, how to call an api in javascript, how to scrape amazon reviews using python, javascript api call example, extract data from amazon to excel, crawl amazon products, shipping api service delivery description, amazon product advertising api script, site script product information, product registration program script, script extract information website, program extract facebook information, amazon product advertising api script php, product advertising api script, extract product information website images

Về Bên Thuê:
( 35 nhận xét ) faridabad, India

ID dự án: #18695651

4 freelancer đang chào giá trung bình $219 cho công việc này


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. Thêm

$250 NZD trong 4 ngày
(17 Nhận xét)

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.

$250 NZD trong 5 ngày
(2 Nhận xét)

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 Thêm

$222 NZD trong 10 ngày
(1 Nhận xét)

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 Thêm

$155 NZD trong 3 ngày
(0 Nhận xét)