eBay Reports Bulk Upload/File Exchange Template Changing Action from Add to Draft on Spreadsheet

[dybe4453]

Hi,

I'm hoping someone can help me with the Reports Bulk Upload Tool.

I was using the xlsx listing template with the dropdown menus but have migrated to the csv listing template.
The reason for this is I don't want to deal with S3 and picture hosting as I need the images to be stored in a local file path for a custom SKU barcoding application.

I have replaced the header on the csv listing template with the details on the csv draft listing template.
The upload is working and the listings are being accepted as drafts, however there are errors.

I have played around and read up on adding more item specifics and have added as many as I can.
As I list in hundreds of different vehicle categories there are too many different item specifics and it would result in 100+ C: columns in my spreadsheet.
As I already need to go into the drafts to add images, video and vehicle compatibility for eBay Motors I'm fine with adding extra item specifics whilst there.

When going into the bulk edit tool to update my drafts I'm met with errors of fields missing.
The error fields are;

Offers
Location
Return Policy
Payment Policy
Postage Policy
Shipping Profile Name
Buy It Now Price

It's easy enough to update Location, Return Policy and Payment Policy via bulk edit but I'd much prefer if the spreadsheet did it.

My column headers for these fields are;

BestOfferEnabled
Location
PostalCode
Return policy
Payment profile name
Shipping profile name
BuyItNowPrice

I have also tried the item dimension headers that I previously had in my list upload but they do not work in a draft upload.

Those column headers are as follows;
WeightMajor
WeightMinor
WeightUnit
PackageLength
PackageDepth
PackageWidth
PackagingHandlingCosts

I have searched through the most recent eBay Reports guide, advanced eBay File Exchange guide and the API documentation and can't find any answers.

Does anyone actually know the complete array of headers that are accepted by the draft action?
Does anyone know the correct value for the BestOfferEnabled column?
I'm not sure if the boolean value of 1 is still accepted or if I should be putting my price in a Start Price header instead of BuyItNowPrice?

Any help would be appreciated...

[tools_apps_team@ebay]

---

@dybe4453 wrote:

Hi,

I'm hoping someone can help me with the Reports Bulk Upload Tool.

I was using the xlsx listing template with the dropdown menus but have migrated to the csv listing template.
The reason for this is I don't want to deal with S3 and picture hosting as I need the images to be stored in a local file path for a custom SKU barcoding application.

I have replaced the header on the csv listing template with the details on the csv draft listing template.
The upload is working and the listings are being accepted as drafts, however there are errors.

I have played around and read up on adding more item specifics and have added as many as I can.
As I list in hundreds of different vehicle categories there are too many different item specifics and it would result in 100+ C: columns in my spreadsheet.
As I already need to go into the drafts to add images, video and vehicle compatibility for eBay Motors I'm fine with adding extra item specifics whilst there.

When going into the bulk edit tool to update my drafts I'm met with errors of fields missing.
The error fields are;

Offers
Location
Return Policy
Payment Policy
Postage Policy
Shipping Profile Name
Buy It Now Price

It's easy enough to update Location, Return Policy and Payment Policy via bulk edit but I'd much prefer if the spreadsheet did it.

My column headers for these fields are;

BestOfferEnabled
Location
PostalCode
Return policy
Payment profile name
Shipping profile name
BuyItNowPrice

I have also tried the item dimension headers that I previously had in my list upload but they do not work in a draft upload.

Those column headers are as follows;
WeightMajor
WeightMinor
WeightUnit
PackageLength
PackageDepth
PackageWidth
PackagingHandlingCosts

I have searched through the most recent eBay Reports guide, advanced eBay File Exchange guide and the API documentation and can't find any answers.

Does anyone actually know the complete array of headers that are accepted by the draft action?
Does anyone know the correct value for the BestOfferEnabled column?
I'm not sure if the boolean value of 1 is still accepted or if I should be putting my price in a Start Price header instead of BuyItNowPrice?

Any help would be appreciated...

---

Hello @dybe4453 ,

The only fields in the "Create new drafts" template are the following:

Custom label (SKU)
Category ID
Title
UPC
Price
Quantity
Item photo URL
Condition ID
Description
Format

Are you trying to add additional fields? I've had success adding Item Specifics (C:Color, C:Size, etc.). If you add Item Specifics, be sure not to include an asterisk in the column header.

As for other adding other fields to the "Create new drafts" template, I'm afraid that would not work.

One thing you might consider would be to use the "Create new listings" template, but schedule the listings to start at a later time. You could enter a dummy URL in your file. You could then edit the scheduled listings before they go live to add the actual pictures (and make any other changes you need to make).