When I export a product the SKU and Barcode columns contain an apostrophe added before the number. (see image)
The apostrophe is not in the product. Is it being added for a reason? Should I keep it in front of all SKUs and Barcodes when I create new products in spreadsheet? Thank you
I had the same issue and was able to identify the apostrophe’s appear when the CSV file is opened with Excel. Excel places an apostrophe on a series of numbers to ensure they are treated as text and not a calculation. If there is a letter in your Variant SKU, the apostrophe does not appear.
The solution: You can remove the apostrophe in Excel before you import, just check to make sure it is formatted as text so Excel doesn’t treat it as a calculation. If you have a bunch of products, you can use the Text to Columns feature to remove the apostrophe.
Hope this helps!
