This screen can be used to import special prices of a customer from a csv file. Use a csv file with correct format to make it valid for this importing process. Download the template by clicking the Template button on the screen.
Mapping of CSV field to Customer | Pricing tab
| CSV Column | Pricing Field | Remarks |
|---|---|---|
| id | ||
| customer_id | Enter the Customer Entity No. | |
| customer_location | Customer Location | Enter the Location Name |
| price_basis | Price Basis | Enter the Price Basis Code |
| cost_to_use | Cost to Use | |
| origin_vendor_no | Origin Vendor No. | Enter the Entity No |
| origin_vendor_location | Origin Vendor Location | Enter the Location Name |
| item_no | Item No. | |
| item_category | Item Category | |
| customer_group | Customer Group | Enter the Group Name |
| deviation | Deviation | |
| line_note | Line Note | |
| begin_date | Begin Date | |
| end_date | End Date | |
| fixed_rack_vendor_no | Fixed Rack Vendor No | Enter the Entity No |
| fixed_rack_no | Fixed Rack No | |
| fixed_rack_vendor_location | Fixed Rack Vendor Location | |
| invoice_type | Invoice Type |
Pages
Overview
Content Tools