Đang Thực Hiện

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.

Best regards,



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

Xem nhiều hơn: amazon scraper python, amazon scraper chrome extension, data scraper, web scraper, how to scrape amazon reviews using python, parsehub, crawl amazon products, extract data from amazon to excel, script extract messages file mail, username use paypal api service oscommerce, vehicle model information web service, 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: #18676168

Được trao cho:


I am proficient with Microsoft Excel and marco/VBA development. I read your project descriptions carefully. I checked the attached workbook as well… I can write the API marco to retrieve report as requested. You’re Thêm

$500 NZD trong 10 ngày
(23 Đánh Giá)

21 freelancer đang chào giá trung bình $540 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

$600 NZD trong 10 ngày
(18 Nhận xét)

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Nice, had a quick read through of the requirements. Glad to look deep Thêm

$750 NZD trong 10 ngày
(14 Nhận xét)

Hi, Reading your project description about writing script that will scraping product data from API services makes me feel like you have me in mind when creating the project. I have all it takes to deliver. Before y Thêm

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

Hi, I have read your project description this will be done in your required time spam with 100% Satisfaction. Kindly message me so we can discuss in detail over chat......

$277 NZD trong 4 ngày
(8 Nhận xét)

Hi, I can continue developping the Excel VBA solution and add to it the options, OR can also start from skratch. An Excel workbook where user will enter the otpions (parameters) and run the macro to download and clean. Thêm

$555 NZD trong 5 ngày
(6 Nhận xét)

I have 4 years experience in Excel VBA, VB, Google Spreadsheet, Google Spreadsheet Script, JS and more than 10 years in Excel. Thousands of different tasks has been fulfilled from a simple daily routines with formulas Thêm

$750 NZD trong 10 ngày
(7 Nhận xét)

Hi Joey, Greetings!! We have huge experience of building websites. Please chat with us so that we can discuss further Looking forward to your response Thanks & Regards, Suhasini

$833 NZD trong 15 ngày
(2 Nhận xét)

Hello Joey. Thank you for your job posting. Just read your job description carefully and see you are looking for developer who are very expertise in api integration. I understood your business logic and think it's v Thêm

$750 NZD trong 5 ngày
(1 Nhận xét)

hi i have noticed your bid proposal and interested in it I have worked on Angular, Reactjs and React Native on web and hybrid apps. Developed Architectures and System Designs in MongoDb, MySql, Sql Server and Redis. Thêm

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


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

Hello Prospects, After reading your job specifications, It seems that I am the most qualified web specialist to give you the best quality work. Recent Work Portfolio:- [login to view URL] https://www Thêm

$555 NZD trong 10 ngày
(0 Nhận xét)

Hello, Greetings of the day...... I have seen your given requirement that you need a Develop Program/Script to extract product information from API Service. I have an expert level developer and designers having 8 Thêm

$555 NZD trong 10 ngày
(0 Nhận xét)

Hi I can do this job definitely 7 days, 100% Hire me Bingbing

$555 NZD trong 10 ngày
(0 Nhận xét)

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I am a Fu Thêm

$616 NZD trong 7 ngày
(0 Nhận xét)

Hello, Hope you are doing well! We at KrishaWeb are most preferred agency for our client due to 100% recommendation and “5 STAR” rating from our clients which we achieve through an excellent client support as wel Thêm

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

Hi Joey, I can continue developing the Excel VBA solution and add to it the options, OR can also start from scratch. An Excel workbook where a user will enter the options (parameters) and run the macro to download a Thêm

$555 NZD trong 10 ngày
(0 Nhận xét)

Hello , im an experienced full-time developer freelancer, im a web and mobile developer certified in many IT languages I speak English and french Certified in : MYSQL Thêm

$321 NZD trong 10 ngày
(0 Nhận xét)

Dear friend, I have read the instructions in your job and I can assure quality work before the deadline. Can we discuss it please?

$555 NZD trong 10 ngày
(0 Nhận xét)

I am from K cirque IT. Ours is an international IT solution farm in the town and We are here to support you with any kind of IT solution. We have 4 years of experience on website development. Quality is our commitm Thêm

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

This letter is to express my interest in your posting on freelancer.com for an experienced software developer. With hands on experience/training, I am confident I will be an asset to your organization. I enjoy bein Thêm

$555 NZD trong 10 ngày
(0 Nhận xét)