Upload CSV Product file to API2

We need to upload a csv file with our products in to the Play API at a set time each day. The file is already formatted correctly, it just needs to be processed using the HTTP Post method. If you are able to set this up please place a bid.

The full documentation help file is attached, below is what we are trying to do.

Thanks

3.2 Add/Modify/Delete

The main steps in using the ‘Add/Modify/Delete’ method are as follows:

1. Create a batch file in a tab-delimited file format that contains all the necessary column headings (see ‘Batch File Rules’ page 8 and ‘Example Batch Files’ page 11).

2. To add a new listing for a product, enter a row into the batch file where:

a. The ‘product-id’ and ‘product-id-type’ refer to the desired product.

b. All the necessary data fields are populated.

c. The ‘add-delete’ field is set to either ‘a’ or ‘A’, or is BLANK.

3. To modify a currently active listing, enter a row into the batch file where:

a. The ‘sku’, ‘product-id’ and ‘product-id-type’ refer to the listing to be modified.

b. All the data fields to be modified are populated with the new values.

c. All the other necessary data fields are populated with the original values.

d. The ‘add-delete’ field is BLANK.

4. To delete a currently active listing, enter a row into the batch file where:

a. The ‘sku’, ‘product-id’ and ‘product-id-type’ refer to the listing to be deleted.

b. The ‘add-delete’ field is set to either ‘d’ or ‘D’.

5. Upload the completed batch file to the ‘Add/Modify/Delete’ method URL.

Upload

To upload a batch file to the ‘Add/Modify/Delete’ method generate an HTTPS POST request to the following URL, which has the tab-delimited batch file in the message-body.

URL – [url removed, login to view]

Parameter Required Description Possible Values

UploadFor

NO Confirmation of the platform on which the Seller wishes to create their listings.

• PlayTrade

Example Add/Modify/Delete Upload –

POST [url removed, login to view]

Authorization: Basic DXNlcm5hbWU6cGFzc3dvcmQ=

Content-Type: text/xml

message-body

Response

The message-body of the response will contain one of a number of possible messages indicating the outcome of the batch file upload.

message-body Description

SUCCESS The ‘Add/Modify/Delete’ batch file has been successfully received and scheduled for processing.

CUSTOMER_UNAUTHORIZED The authorisation information supplied (i.e. username and password) were invalid. Upload cancelled.

message-body Description

SUCCESS The ‘Add/Modify/Delete’ batch file has been successfully received and scheduled for processing.

CUSTOMER_UNAUTHOR IZED The authorisation information supplied (i.e. username and password) were invalid. Upload cancelled.

Example Add/Modify/Delete Response –

SUCCESS

Procesamiento de datos Excel HTML MySQL PHP

Nº del proyecto: #1652586

Sobre el proyecto