Please refer to TemplateMonster Support for any issues surrounding TemplateMonster/TemplateTuning Themes – thanks, Jigoshop Team

Need help with duplicate SKUs

tannercampbell's Avatar

tannercampbell

08 Apr, 2012 06:47 PM

Using the Jigoshop bulk uploader I'm running into an interesting problem.

I had at one point uploaded around 2,000 products to the store but the csv file was ... poorly formatted. At great effort I combined all 4,500 items into one single csv and split that csv into nine, 500 item, csv's. More manageable that way.

So, I went into the Jigoshop product list and deleted all of the products I had imported before redoing the csv file. Deleted them to the trash, then removed them permanently from the trash. So my store was completely empty ... in theory, anyway.

When I attempted to upload the first set of 500 items, I was only able to upload 48 and was greeted by the summary screen that said "48 items have been created, 452 items have been skipped" then it cited the duplicate SKUs. But those SKUs are no longer in the Jigoshop product list; so what's going on?

I've been through my PHP control panel, checking wp_posts and wp_postmeta (per a random posting I found in the forums) to no avail.

Where is Jigoshop caching my old products? If not in the database, then where? I can't find anything in the bulk uploader plugin folders, nor in the Jigoshop folders.

I need some support for this issue, I'm approaching deadline in 48hours and did not foresee this issue. Please help.

  1. 2 Posted by tannercampbell on 09 Apr, 2012 12:27 PM

    tannercampbell's Avatar

    Anyone?

  2. 3 Posted by Matt on 09 Apr, 2012 01:30 PM

    Matt's Avatar

    Let me fetch Michael, the author of that extension, for you.

  3. 4 Posted by Matt on 09 Apr, 2012 01:33 PM

    Matt's Avatar

    Actually, support for this plugin should be routed here:
    http://www.visser.com.au/jigoshop/plugins/product-importer-deluxe/

  4. 5 Posted by tannercampbell on 09 Apr, 2012 02:29 PM

    tannercampbell's Avatar

    @Matt

    I've just posted the question in the thread you linked me to ... though it seems more like a single wordpress entry with comments below it; I couldn't find a forum.

    Could you please let "Michael" know that I've posted it? I hate to be a pain in the arse, but I do need some help with this, it's relatively urgent.

    Thanks very much,
    Tanner

  5. 6 Posted by isupportu on 23 Jul, 2012 04:42 PM

    isupportu's Avatar

    Tanner - did you find a solution for this? I'm about to run through the same process, and I don't have a good feeling about it.

    Best,
    Erin

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.