How can i update quantities for thousands of bonanza existing items (originally imported from ebay) using a csv file if the existing items do not have skus?

Hello! We have over 5000 Bonanza items in our booth. We originally imported them from EBay. Consequently, many of them do not have SKUs. They all, of course, have unique Bonanza-generated “item ids”, but the CSV file does not work with Bonanza Item IDs, only SKUs as far as I have tested.

When I try to upload a CSV file with Bonanza Item Ids in the “ID” column, the items are Imported, not Updated. So I end up with, for example, my original item with Bonanza ID of 1234567 and another separate item with a SKU of 1234567!

How do I get a CSV file to match an existing item on Bonanaza Item ID, not SKU? Is that possible?
(Also, I cannot use the Bonanza API to update quantities for thousands of items either as Bonanza limits the number of API calls per day… so I am really stuck here)

Thanks for any help! (Perhaps I am missing something obvious?)

—Paulette

asked Translation missing: es.datetime.distance_in_words.over_x_years ago

prmagic
Reputation: 10
See prmagic's booth
1 Answer

This is an official Bonanza response.

Accept hover

Hello @prmagic,

Thanks for reaching out and sorry for the trouble. Listings imported from eBay cannot be updated via CSV File. Only listings that have been originally uploaded via CSV file can be managed via CSV. Certain conditions must be true

1) id column must be used and cannot ever change
2) listings must have been originally uploaded via CSV
3) force_update set to TRUE must be included in the CSV file. It is force_update set to TRUE that is the mechanism that triggers posting changes.

If your inventory is changing on eBay and you want it to update in your Bonanza booth, you will want to turn on your eBay sync. You can do this from the “My Booth > Import from eBay” page by clicking the “Import items” button (when that button is visible, it means your inventory sync is currently turned off). If you are changing other aspects of your listings on eBay (price, title, description, images, etc), you will want to update your advanced import options to “Revise previously imported listings” prior to importing your items. Otherwise, the sync feature will skip the listings which already exist in your booth and changes will not be copied to Bonanza.

While the importer is designed to remove listings which are sold on eBay from your Bonanza booth, it will not remove any items which have been manually ended by the seller on eBay for the following reasons (you will need to manually remove these listings from your Bonanza booth, as well):
-Item no longer available
-Damaged or lost item
-Error in listing

Hope that information helps and we apologize for any inconvenience. Let us know at our support department if you have additional [URL removed]

[URL removed]

Thanks!
The Bonanza Team

answered Translation missing: es.datetime.distance_in_words.over_x_years ago

Katyoke
Reputation: 1512
See Katyoke's booth
Question Vitals

Viewed: 3361 time

Asked: Translation missing: es.datetime.distance_in_words.over_x_years ago

Latest response: Translation missing: es.datetime.distance_in_words.over_x_years ago

To Answer Brilliantly

Remember these tips:

  • Use links to other sources to support your opinions
  • Use examples where possible
  • Put yourself in the inquirers shoes: what extra info would be helpful?

Should I post a comment or an answer?

You can only post one answer, so make it count. Maybe your reply is more fitting as a comment instead?

Post an answer for:

  • Replies that directly and specifically answer the original question

Post a comment for:

  • "Thanks," "Me too," "I agree," or "Works for me" types of replies
  • When you would like the original poster to provide more details
  • When you have more to add to someone else's question or answer

See also our Roundtable FAQ.

Formatting

Community help posts follow certain formatting guidelines, which may impact the look of your post. If you're interested in tweaking the format, instructions are available here.