- Before you start, you’ll need to have some information ready:
- The SKUS, handles, supply price and inventory count of the products which can be copied over from the Product sheet.
- Creating a PO CSV
- Importing your PO CSV
To Create your PO CSV
- Download a template:
Download the template from the google drive folder ‘Data’ created for you by Cloudscape Technologies.
- Add your products:
This is an ID for your product. Make sure it only has letters and numbers. You cannot have spaces or symbols in here.
You can also choose to leave this column blank and allow Vend to automatically generate unique handles for your new products. This will be a system generated unique code, so we only recommend doing this if you don't already use a pre-existing handle format.
The stock keeping unit for your product. You can scan or type the existing barcode number for your product here if you have one.
Otherwise, you can leave this column blank and Vend will automatically generate unique SKUs for your new products.
Every product must have a unique SKU. Make sure it only has letters and numbers. You cannot have spaces or symbols in here.
The supply price for your product, excluding tax. Don't include a currency sign, just put the number.
You should always include a supply price - if your product price fluctuates, you can specify the exact price for each order when you complete a stock order.
Quantity This is where you will fill in the stock or number of items being ordered. (or the initial stock if you are doing the initial stock upload)
Next, we can move to uploading this PO Sheet.