SKU question

Author	« Topic »
DavidX Ecommerce Template Expert 936 Posts	Posted - 07/15/2018 : 14:22:30 I'm wondering why my SKUs look different when viewing them in a CSV file as opposed to online or through the admin page. An example is this: 75960608000700411 which is correct and this: 75960608000700400 which is how it shows on the CSV. I've also noticed that, If I upload the CSV file, it will change all of the "11"s on the end to "00"s I'm using Open Office Calc. Edited by - DavidX on 07/15/2018 14:42:41
dbdave ECT Moderator USA 10468 Posts	Posted - 07/15/2018 : 14:56:42 It's usually leading zeros that seem to have problems in excel. Here is what I would do. Change the SKU to something totally different. Use letters maybe. Then download the csv and view in open office calc to see what you get. This might help narrow the issue to the zeros. Don't forget, you can open a csv file in notepad, so maybe see what you have there too. Edited by - dbdave on 07/15/2018 14:58:15
DavidX Ecommerce Template Expert 936 Posts	Posted - 07/15/2018 : 15:01:15 I'm using actual UPCs for the SKUs so I really don't want to change them. Also I'm using Open Office Calc.
Marshall Ecommerce Template Guru USA 1916 Posts	Posted - 07/15/2018 : 15:36:43 You are not using Open Office spreed sheet? It does not change numbers, even leading zeros. Marshall CENLYT Productions - ms designs Affordable Web Design Custom Ecommerce Designs Responsive Websites Cenlyt.com
dbdave ECT Moderator USA 10468 Posts	Posted - 07/15/2018 : 23:17:11 quote: I'm using actual UPCs for the SKUs so I really don't want to change them. Also I'm using Open Office Calc. Hi DavidX, I was meaning as a simple test. I suspect perhaps it's some other unknown issue and if you temporarily change one in the admin and then download the csv, you can rule out the ending zero problem I think.
DavidX Ecommerce Template Expert 936 Posts	Posted - 07/18/2018 : 13:42:26 It seems to be happening on upload. When I download a CSV any SKUs with "11" on the end remain that way but, if I upload the same file I downloaded they change to "00" on the site. Edited by - DavidX on 07/20/2018 12:34:40
Phil ECT Moderator United Kingdom 7715 Posts	Posted - 07/21/2018 : 01:36:57 Hi David, Here's what you need to do. Download the csv, open it, highlight the SKU column > right click > format cells > choose text. Save the file but keep it open. Make your changes > save > upload Closing the file and reopening it will change the format of the SKU's so you need to keep it open. * Database Migrations and Conversions* * ASP to PHP Cart Conversions* *Contact Us* *Buy The PHP Capture Card Plugin* Rate Our Services/View Our Feedback
	« Topic »