Variant products not ordered by SKU in the inventory and details on the Sell Screen


Latest update: - Sam Pallesen

Problem

Variants display in a different order in the inventory and details section of the Sell Screen, rather than being ordered by SKU.

Setup

  • Vend for Mac
  • Apache OpenOffice (free to download)
  • Chrome Browser

Cause

When you upload a product via CSV, Vend will take the order from the CSV file and will not sort the variants into any particular order. In order to sort these in a particular order, they need to be imported in that order. The only solution to this issue is to delete the product with variants and re-upload it.

Solution

  1. Click Products
  2. Click Enter name, SKU, handle or supplier code
  3. Enter the name of the product you want to fix
  4. Click Apply Filter
  5. Click Export List
  6. Click on Click to start download
  7. Find the file at the bottom of the Chrome window
  8. Click on the tent icon

    Screen_Shot_2018-11-30_at_16.20.01.png

  9. Click Show in Finder
  10. A Finder window will come up on the screen
  11. Find the file product-export.csv in the list
  12. Right click on the file
  13. Click Duplicate
  14. Right click on the file
  15. Hover the mouse cursor over Open With
  16. Click OpenOffice
  17. Down the bottom of the dialogue box that comes up, find the sku column
  18. Just above sku, click Standard
  19. Click the column type drop-down
  20. Select Text
  21. Click OK
  22. Click Data
  23. Click Sort...
  24. In the Sort by column select sku
  25. Click OK
  26. On your keyboard, press command + s
  27. Navigate back to your Chrome window
  28. In Vend, click on the name of the product you want to fix
  29. Click Delete Product
  30. Click OK
  31. Click Products
  32. Click Import
  33. Click Browse
  34. Click product-export.csv
  35. Click Open
  36. Click Continue with Import
  37. Your product will now show up ordered by SKU

Additional Information

When you delete a product you lose all previous reporting data for that product. This means that the previous sales reports and inventory movements for the product will be no longer be available.