Ascora Support
Space shortcuts
Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 17 Next »

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.

(info)  Important Tips:

  • Use the standard import template which you can download from Inventory → Supplies → Import/Export → Download Import Template.
  • Make sure there are no formulas in the price file and if there are formula based data, paste them again as values. For more information, see How to remove formulas or paste data as values in Excel? user guide.


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

Provided that you use the standard import template and there are no formulas in 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 in 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. 




After clicking Import, you should see the Import Results such as number of records imported.

If there is no error message, it means that all data have been imported successfully.


Identifying Error Messages

After clicking Import, it should show you an indicator if successful with nil errors (just like the above example), otherwise, an error message will be shown and you can import again after making the necessary corrections.

Examples of Error Messages

Cost Has Not Been Modified


Supply Not Found


We've now completed the process of importing price only changes.


  • No labels