Bonanza
Search
Shop by Category
Father's Day
Moda Mujer
CATEGORÍAS
OFERTAS
MEJORES MARCAS
Moda Hombre
CATEGORÍAS
OFERTAS
MEJORES MARCAS
Hogar & Jardín
CATEGORÍAS
MEJORES MARCAS
Salud y Belleza
CATEGORÍAS
MEJORES MARCAS
Coleccionables y Arte
CATEGORÍAS
Bolsos
MEJORES MARCAS
Joyería
CATEGORÍAS
Cupones
Más categorías
CATEGORÍAS
More Ways to Shop
More
I need help with importing a csv file
Upvote this question 0 Downvote this question

The column descriptions for the things I’m having trouble with from my supplier’s CSV file are as [URL removed]

“ID – The id of each parental item. This is a “group” identifier. Items with the same ID are related. For example, rows indicating individual sizes of the same t-shirt will have the same ID but different SKUs”

“Group ID – Related skus have the same “GROUP ID” in the file. For example, SKUs for sizes small, medium, large and x-large of the same t-shirt will all have the same “GROUP ID” but a different sku for each size.”

When I upload the file I get a message saying

“[URL removed] 2072 items were skipped because an item with the same id is already being imported”

I think this means it is only importing one size for each of the different groups of shirts rather than all of the sizes available for each shirt group. Is this something I can fix with the custom column mapping or can anyone suggest the best way to get it to accept all of the items? I took a class in college learning how to work with office files but it was years ago and any knowledge I gained about CSV files is escaping me now that I need it. Any help would be greatly appreciated.

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

ForeverMSowells
Reputation: 20
See ForeverMSowells' booth
1 Answer
Upvote this answer 0 Downvote this answer
Accept hover

are you using the format bonanza provides for csv or something else..each ID needs to be unique..so you may have to change the your file headers to fix this

maybe this will help
https://www.bonanza.com/site_help/item_imports/csv_import

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

ccmom
Reputation: 12648
See ccmom's booth

6 Comment

ForeverMSowells says: October 12, 2018

I think I will be able to fix it by mapping my soul column to bonanza’s id column. It shows that my upload is still in progress so do you know if I would I have to wait until it’s done to edit the mapping or whether it is still editable after it’s finished uploading or if that is something uploading

ForeverMSowells says: October 12, 2018

In other words should I cancel the current upload and start over or can the custom column mapping be edited afterwards?

TrinketBox says: October 13, 2018

I would wait for a bit to see what happens, and yes, things can be edited afterwards in batch edit or with a csv, but it is not something I have ever done personally. I just edit/list manually most times..since there is not that much to change

TrinketBox says: October 13, 2018

Did not realize I was using my other ID…(ccmom, aka Cindy)

kawartha_ephemera says: October 28, 2018

Hopefully the OP has already solved their csv import problem by now but here’s a suggestion that worked for me. Create a few new listings using the Bonanza listing tools. Once the listings are setup properly

kawartha_ephemera says: October 28, 2018

go into the batch editor and download a csv file of the just created listings. The downloaded file provides an accurate format to use for an import csv file.

Question Vitals

Viewed: 1305 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.