Difference between revisions of "Import Customer Pricing"
Jump to navigation
Jump to search
(Initial Setup.) |
m (corrections made) |
||
| Line 3: | Line 3: | ||
The format of the file must be either a "txt" or "csv" file in the following format: | The format of the file must be either a "txt" or "csv" file in the following format: | ||
| − | "sku", "price", " | + | "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. | 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 15:40, 20 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
