Importing

<< Click to Display Table of Contents >>

Navigation:  Table editors > Material >

Importing

At minimum, the Material Table import file must contain the following columns: material_code.

 

If you supply row_id, make sure each value is unique. Here is an example:

 

clip0524

 

You can open Notepad or Excel and copy and paste the sample below to create your own import file. At you discretion, Include or exclude any of the columns and values that are not required.

 

"row_id","material_code","description","parent_name","source","ticket_unit","invoice_unit","unit_price","additional_fee","minimum_charge","charge_code","cost_unit","cost_rate","cost_fee","cost_code","ticket_table","print_ticket","print_barcode","taxes_payable"

1,"014.01","SP-19","","1","kg","MT",0,0,0,"","MT",0,0,"","",1,0,""

2,"014.02","SP-19","","1","kg","MT",0,0,0,"","MT",0,0,"","",1,0,""

3,"2CR","2CR","","1","kg","MT",0,0,0,"","MT",0,0,"","shipment_ticket",1,0,""

4,"2R","2 INCH CRUSHER RUN","","1","kg","MT",4.04,0,0,"01300","MT",0,0,"01300","shipment_ticket",1,0,";3:HST5:TOARC"

5,"2RCA","2RCA","","1","kg","MT",0,0,0,"","MT",0,0,"","shipment_ticket",1,0,""