Đã Đóng

Develop Program/Script to extract product information from API Service-1

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.

Best regards,



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

Xem nhiều hơn: script extract messages file mail, username use paypal api service oscommerce, vehicle model information web service, javascript api call example, extract data from amazon to excel, crawl amazon products, how to call an api in javascript, how to scrape amazon reviews using python, amazon scraping service, amazon scraper python, price comparison api php, coupon software program script, free cash program script, using perl script extract http cookies, product review writing service, video script extract youtube, program need extract information screen, write script extract information website, product registration program script, script extract information website

Về Bên Thuê:
( 1 Nhận xét ) Auckland, New Zealand

ID dự án: #18682621

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]

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

Hi, You won’t make the right candidate selection without knowing what your project on writing script that automate the scraping of product information from API Service will look like. Fortunately, I can show you how y Thêm

$250 NZD trong 3 ngày
(15 Nhận xét)

I have excellent command on MS Excel and have worked with various APIs before and can write a script that will extract all products with options as per the requirements mentioned. I have completed complex projects in E Thêm

$250 NZD trong 3 ngày
(6 Nhận xét)

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

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

I will do your work in Cheapest Price thats my Promise. Contact me to discuss more in detail...message me

$88 NZD trong 3 ngày
(4 Nhận xét)

Hi Joey, I am excel freelancer, I have gone through your job description, check [login to view URL] with your username/password & interested to work on your project. by checking the banggood site i found that they hav Thêm

$150 NZD trong 3 ngày
(1 Nhận xét)

Glad to help you develop a script to extract product information from API Service. I have worked on similar integrations before and Excel and VBA have no secrets for me. I speak fluent English and when you hire Thêm

$799 NZD trong 21 ngày
(0 Nhận xét)