If you change a product SKU, does it really delete all reporting data for the old SKU inst[...]

So if you try to change a product SKU, you get a message saying all data history for reporting will be lost, and this seems to indeed be the case (I tested it with a couple dummy SKUs). Is there any way around this besides cloning the current SKU and having to run any future product sales history reports including both SKUs? Hopefully that makes sense...

Find more posts tagged with

Import/Export

Orders & Inventory

Webstore

Accepted answers

All comments

Erik Merkley

Changing SKUs in Neto is a really, really bad idea. Unfortunately from the very early days, Neto used a product's SKU as its "key" to link it to everything else in the system. Even though they let you change a SKU, the warning is there for a reason. I can guarantee you'll break more than just reporting. You should never change a SKU which has had any transactions or stock against it. Best to just clone it and deactivate the old one.

Anna Goebel

Thanks for the info!

Heide Hackworth (1374)

I wish we could delete old sku's we entered by mistake and never used. There is no way to delete skus!

Erik Merkley

You should be able to delete a SKU which has no transactions (purchases or sales), even if you have Neto Advanced Inventory.

Go to View Products > tick beside a SKU > "With 1 Selected" at the bottom > Delete

Heide Hackworth (1374)

Thanks Erik - we do have Advanced Inventory. Bit when we select a sku, even one that has not had any transactions against it, there is no 'Delete' that comes up in the bottom menu.

Erik Merkley

Oh sorry, you are right - SKUs can't be deleted if you have Advanced Inventory. Documented here:

https://www.netohq.com/support/s/article/add-and-manage-products#9

Best you can do is deactivate them.