Difference between revisions of "Import Customer Pricing"
Jump to navigation
Jump to search
m (corrections made) |
m (corrections made) |
||
| Line 1: | Line 1: | ||
The system allows full customization of customers own pricing. You can use this feature to import them on mass. | The system allows full customization of customers own pricing. You can use this feature to import them on mass. | ||
| − | The format of the file must be either a "txt" or " | + | The format of the file must be either a "txt" or "CSV" file in the following format: |
| − | " | + | "SKU", "price", "quote old price" |
| − | * | + | *SKU (required) |
*Your SKU / Reference | *Your SKU / Reference | ||
| − | * | + | *Price (required) |
*Price for Customer (Excluding VAT/GST) | *Price for Customer (Excluding VAT/GST) | ||
*quote old price (optional) | *quote old price (optional) | ||
| Line 18: | Line 18: | ||
Remember, when saving from Excel, it must be a basic CSV file, sometimes Excel adds funny characters at the beginning/end of the file, and you will be greeted with several errors saying no fields are found if this is the case. | Remember, when saving from Excel, it must be a basic CSV file, sometimes Excel adds funny characters at the beginning/end of the file, and you will be greeted with several errors saying no fields are found if this is the case. | ||
| − | If you would like us to check your file, please email it to support@spitfire-ams.co.uk | + | If you would like us to check your file, please email it to '''support@spitfire-ams.co.uk''' |
Revision as of 09:45, 30 September 2021
The system allows full customization of customers own pricing. You can use this feature to import them on mass.
The format of the file must be either a "txt" or "CSV" file in the following format:
"SKU", "price", "quote old price"
- SKU (required)
- Your SKU / Reference
- Price (required)
- Price for Customer (Excluding VAT/GST)
- quote old price (optional)
- Customers old Supplier Pricing for Comparison. This is used on Quotations to show Customers their savings if changing suppliers.
- Browse
- Browse your Computer for the relevant Text/CSV file.
- Please Select Customer
- You can search by Customer (Company) Name here.
Remember, when saving from Excel, it must be a basic CSV file, sometimes Excel adds funny characters at the beginning/end of the file, and you will be greeted with several errors saying no fields are found if this is the case.
If you would like us to check your file, please email it to support@spitfire-ams.co.uk
