Bonanza
Search
Shop by Category
Father's Day
Women's Fashion
CATEGORIES
DEALS
TOP BRANDS
Men's Fashion
CATEGORIES
DEALS
TOP BRANDS
Home & Garden
CATEGORIES
TOP BRANDS
Health & Beauty
CATEGORIES
TOP BRANDS
Collectibles & Art
CATEGORIES
Handbags
TOP BRANDS
Jewelry
CATEGORIES
Coupons
More Categories
CATEGORIES
More Ways to Shop
More
Update sku with csv file
Upvote this question 0 Downvote this question

I have downloaded the csv file from Bonanza. I have figured out the SYLK file issue because the first column is “ID” instead of “id” but my description column exports as a bunch of html gibberish that skews the export file in excel. Since description is a required column (why?) in order to update inventory, how do I add just the sku column without having to delete and re-import inventory?
To explain why I need this, I have a trait called “Inventory ID” that I used for the unique identifier in my point of sale system which does not download on the orders csv file but the trait “sku” does. So I want to transfer the “Inventory ID” trait value to “sku” value. It seems a simple task and I have used many different csv files on different platforms but for some reason I can not figure out Bonanza.com to upload “sku” data to the respective listings
Any ideas?

asked over 8 years ago

Nordstromsauto
Reputation: 12
See Nordstromsauto's booth
1 Answer

This is an official Bonanza response.

Hi @Nordstromsauto,

Thanks for reaching out and sorry to hear about the trouble with your CSV file. The data entered in your “id” column is treated as your item SKU. To upload the SKU, you can use either “sku” or “id” (all lowercase) on your CSV file. Here is more information on how to format and upload a CSV file on [URL removed]
[URL removed]

Hope that information helps. If you are still experiencing issues uploading your SKU, please send detailed information for what you are attempting to do to [email protected] where we have the tools to better assist you.

Thanks!
The Bonanza Team

answered over 8 years ago

BonanzaKaty
Bonanza Staff
See BonanzaKaty's booth

2 Comments

prmagic says: January 18, 2016

Katy, How can I update an existing item using a CSV file if the existing item does not have a SKU? Thanks!

Nordstromsauto says: January 27, 2016

The current “id” is not the same as my “sku” but I was trying to add “sku” to the listing since it is one of the columns that are available for order export. I did contact support with details though, thank you for your reply

Question Vitals

Viewed: 1155 times

Asked: over 8 years ago

Latest response: over 8 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.