After you have created your products in the inventory, update your prices and stock levels automatically to avoid problems
This help article is written for our suppliers and will not be relevant if you are an Avasam seller. To access seller-specific articles, please follow this link.
Updating products
If you need to update a product or products, and you're not using an integrated software solution such as Linnworks, we recommend that you use a product feed file for detailed changes or a stock and price feed file for updating stock levels and prices.
When Avasam finds a file named Avasam Supplier Stock and Price Feed.csv in a specified FTP folder on our server, it will import it and then delete the file to confirm that it has been imported successfully. Contact our support team if you don't have access to this FTP folder.
Stock and price feed columns
| Column name | Description | Mandatory |
|
ProductId |
Internal identifier/SKU for product | Yes |
| StockQuantity | Current available stock level | Yes |
| PriceExclVAT | Net price to seller. Ex VAT | Yes |
| RRPExclVAT | Recommended Retail Price, ex VAT | Yes |
| VAT%Rate | VAT rate to apply to product as whole number (e.g. "20", "0") | Yes |
| ShippingCountry | 2 digit country code for the country you ship the product from (e.g. GB, US, ES) see ISO 3166 country codes http://www.iban.com/country-codes | No |
You can use quotes around the information in individual fields, but it's not compulsory.
For example:
"10.99" is the same as 10.99
"Sony" is the same as Sony