How to change products back to default loyalty using a spreadsheet

Objective

Change products with a custom loyalty back value to the default loyalty setting by using a spreadsheet upload to update the custom loyalty value to null.

Setup

  • Vend for Mac or PC
  • Chrome (other web browsing software may also be compatible)
  • OpenOffice (other spreadsheet editing software may also be compatible)

Steps

  1. Click Products
  2. Click Export List...
  3. Double click on the file to open it

    Screen_Shot_2020-07-29_at_12.05.35.png

  4. Find the name of the product which you want to change the loyalty for
  5. In the loyalty_value column, click on the cell in the same row as the name of the product which you want to adjust the loyalty for
  6. Type in the word 'null' (without the apostrophes)
  7. If you are editing the file while any of your stores are currently open and actively trading, delete the inventory columns before continuing (generally this is all columns to the right of column AC)
  8. Save the file by clicking on the floppy disk icon in the top left-hand corner of the window screen
  9. In your Vend store, click on Products
  10. Click Import
  11. Click Chose a File to Upload...
  12. Select the file which you have just edited
  13. Click Open
  14. Click Continue with Import
  15. Wait for the product to import. Once it is finished importing your products will now show the default loyalty setting 
Did this answer your question?
Have more questions? Contact us so that we can help you out.