Reset SKU

Jan 2nd, 2011 at 06:35 PM
User 187934 Photo

Eric Rohloff
Senior Advisor
20,190 posts

Is there any way to reset sku numbers? I deleted some products and when you copy a product to another category it keeps indexing the sku number. I now have products with sku's from SKU_00000001-SKU_00000012 and when I copy lets say product SKU_00000001 to another category it numbers it's SKU_00000096 even though my highest SKU that I currently have is SKU_00000012.:/

I know I can manually change them but if there's a better way.:cool:
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
Jan 2nd, 2011 at 06:54 PM
User 103173 Photo

Scott Swedorski
VP of Software Development
0 posts

Sorry, but there is no way to reset that in the software automatically.
Learn the essentials with these quick tips for Responsive Site Designer, Responsive Email Designer, Foundation Framer, and the new Bootstrap Builder. You'll be making awesome, code-free responsive websites and newsletters like a boss.
Jan 2nd, 2011 at 08:03 PM
User 187934 Photo

Eric Rohloff
Senior Advisor
20,190 posts

Thanks Scott.:)
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
Jan 2nd, 2011 at 11:58 PM
User 187934 Photo

Eric Rohloff
Senior Advisor
20,190 posts

Oh! I just figured it out. I'll make a csv file in excel and import all my data with the sku's the way I want them. Not to mention it's a lot easier to copy and replace data using excel.:cool:

Edit
It only took me about 5 minutes to do the csv in excel. Plus for my application I'm using the same image for the products(Rent) so I'll save space and have a faster upload. It imported smooth as silk.:)
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
Jan 3rd, 2011 at 07:59 AM
User 103173 Photo

Scott Swedorski
VP of Software Development
0 posts

That is a great idea and look how it easy using a CSV file was. There are others I have seen that have tried for days to get that to work and you did it in 5 minutes! :)
Learn the essentials with these quick tips for Responsive Site Designer, Responsive Email Designer, Foundation Framer, and the new Bootstrap Builder. You'll be making awesome, code-free responsive websites and newsletters like a boss.
Mar 8th, 2014 at 07:44 AM
User 596399 Photo

Chris Smith
Registered User
7 posts

Following on from this, can someone advise how Shopping Cart Creator Pro generates the next SKU? There must be a record somewhere in one of the files of which number it is up to.

If this is the case, then surely it is editable.
Mar 8th, 2014 at 08:18 AM
User 187934 Photo

Eric Rohloff
Senior Advisor
20,190 posts

It does them in the order you add them.
So if you currently have 59 products in your shop the next sku added will be
SKU_00000060

You can alter the sku to your needs after the fact.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
Mar 8th, 2014 at 08:44 AM
User 596399 Photo

Chris Smith
Registered User
7 posts

No it doesn't and that's my problem. I have 98 products, the last one being SKU_0000098.

When I add a new one it gives it SKU_0000104. I'm 6 adrift.
Mar 8th, 2014 at 08:59 AM
User 103173 Photo

Scott Swedorski
VP of Software Development
0 posts

Chris Smith wrote:
No it doesn't and that's my problem. I have 98 products, the last one being SKU_0000098.

When I add a new one it gives it SKU_0000104. I'm 6 adrift.

There is no option to reset the numbers. If you do not like the one auto picked, you can enter your own custom SKU.
Learn the essentials with these quick tips for Responsive Site Designer, Responsive Email Designer, Foundation Framer, and the new Bootstrap Builder. You'll be making awesome, code-free responsive websites and newsletters like a boss.
Mar 8th, 2014 at 09:54 AM
User 2147626 Photo

SadDuck
Ambassador
2,958 posts

When I add a new one it gives it SKU_0000104. I'm 6 adrift.

Had you at any point deleted an item? Or made it unavailable in the store? Just guessing here...:P
Graphics for the web, email, blogs and more!
-------------------------------------
https://sadduck.com

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.