Versions Compared

Key

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

...

(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 Remove Formulas or Paste Data as Values in Excel? user guide.


1. Start by accessing Import tab.

...

  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.
    1. Update All - this is applicable when the costs are changing and we keep the mark up the same and adjust the sell price.
    2. Update Only For Default Markup - if you have certain items that are not changing but the rest of the items are set to a certain standard (eg. 20% mark up, 30% mark up.)
    3. Do Not Update Sell Price - will just maintain the cost 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 2099167 section.
  5. Once done, click Import.

...

  • 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. 


Image RemovedImage Added


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

...

Cost Has Not Been Modified


Supply Not Found


Note: You might encounter other error messages not mentioned in this user guide but simply do the necessary changes and you should be able to successfully import the file again.


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

...