Develop Program/Script to extract product information from API Service

종료 등록 시간: 5년 전 착불
종료 착불

Please read both word document and workbook for project details:

Develop Program/Script to extract product information from API Service

Overview:

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

NOTE:

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.

API Excel Macros Excel VBA HTML5 Process Automation

프로젝트 ID: #18695651

프로젝트 소개

4 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 5년 전

이 일자리에 대한 프리랜서 4 명의 평균 입찰가: $219

schoudhary1553

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. 기타

$250 NZD (4일 이내)
(17 리뷰)
4.9
Apisylux

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 (5일 이내)
(2 리뷰)
2.9
brennankelly

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 기타

$222 NZD (10일 이내)
(1 리뷰)
0.7
aswadakdas

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 기타

$155 NZD (3일 이내)
(0 리뷰)
0.0