Difference between revisions of "Import Customer Pricing"
Jump to navigation
Jump to search
(Initial Setup.) |
m |
||
| (3 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | === '''In This Section''' === | |
| + | This is where you can import your customers own pricing. | ||
| − | 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 | |
| − | + | *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@ | + | If you would like us to check your file, please email it to '''support@genisys-systems.co.uk''' |
Latest revision as of 13:24, 15 March 2023
In This Section
This is where you can import your customers own pricing.
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@genisys-systems.co.uk
