Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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. Note that the asterisked columns are required details.

 

 Mapping  Mapping of CSV field to Customer | Pricing tab

CSV ColumnPricing FieldRemarks
id  
customer_id Enter the Customer Entity No.
customer_locationCustomer LocationEnter the Location Name
price_basisPrice BasisEnter the Price Basis Code
cost_to_useCost to Use 
origin_vendor_noOrigin Vendor No.Enter the Entity No
origin_vendor_locationOrigin Vendor LocationEnter the Location Name
item_noItem No. 
item_categoryItem Category 
customer_groupCustomer GroupEnter the Group Name
deviationDeviation 
line_noteLine Note 
begin_dateBegin Date 
end_dateEnd Date 
fixed_rack_vendor_noFixed Rack Vendor NoEnter the Entity No
fixed_rack_noFixed Rack No 
fixed_rack_vendor_locationFixed Rack Vendor Location 
invoice_typeInvoice Type 

 

Pages

Children Display
alltrue
excerpttrue