Importing Price Only Changes

There is an option to update Price Only Changes in Ascora and you can do it by accessing the Import tab.

When you select this option, it is important to note that:

• It updates Supply Cost with options to update Sell Price.

• It does not create new Supplies.

1. Start by accessing Import tab.

2. Look for the field called Import Supplier Pricing and click on it. 

3. Click Select Files to select your CSV file or Excel spreadsheet and then click Begin Import.

4. Complete the configurations (following the references below) and once done, click Import.

1. Select Yes if your data has headers
2. Select Supplier if you're importing for only one supplier
3. Select from the 3 options namely, Update All, Update Only For Default Markup, and Do Not Update Sell Price.
4. Sort out mapping by dragging the items from the left panel to the corresponding field in the right panel. To learn more about how mapping works, please see How Mapping Works section.
   
5. 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.

How Mapping Works

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.