Now it is possible to import prices in bulk using spreadsheets (.csv and .xlsx) for easier price management.
1. Go to Catalog → Customer Price → Create New → Import:
2. A pop-up window will be shown with text and sample file:
3. A sample file will show what is needed in order to import file:
- Organization ERP ID
- Offer ID
- Vendor name
- Markup %
- From date
- Till date
- Price source (In Price or ERP)
- Soft limit %
- Hard limit %
Once the file has been filled with needed information - markups, vendors, ERP ID, and other needed fields, you can Import file. Press on Select File → Upload file and continue.
Errors and/or conflicts will be shown with details in a pop-up window, with information that needs to be corrected. The file will not be imported until corrections are made in a new file and imported once again.
Confirmation that prices are imported will be shown and managed further in Price Management Section.
Note, that the earliest day when prices can be applied and effective, is the next day. In case you are trying to import prices with today's date, you will receive the following message: