Import Customer Special Price From CSV
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 |
|