...
It updates Supply Cost with options to update Sell Price.
It does not create new Supplies.
|
1. Start by accessing Import tab.
...
- Select Yes if your data has headers
- Select Supplier if you're importing for only one supplier
- Select from the 3 options namely, Update All, Update Only For Default Markup, and Do Not Update Sell Price.
- Sort out mapping by dragging the items from the left panel to the corresponding field in the right panel. Refer to step 5 for more details on how mapping works.
- Once done, click Import.
Note: You have the option to save mapping by clicking Save New Mapping so you can select it the next time you do a similar import.
5. How to map the imported data correctly.
Providing that you use the standard import template and there are no formulas on the import file, the importer is able to read or identify the data and assign them to the corresponding fields.
- For example, if column A on your Excel sheet is the Part Number, the importer automatically maps it to the field called Part Number. See image below as an example.
However, there are instances when some of the imported data need to be manually mapped and you can do it by dragging the data to the corresponding fields
- In this example, we need to manually map the data for Supplier. To do this, click the box on the left panel then drag to the right panel and drop in the box called Supplier.
