Catalogs
      Back to home
      1. Help Center
      2. For Suppliers
      3. Catalogs

      Update Prices via CSV Import

      Learn how to rapidly update your Catalog prices in bulk, using our Import Catalog by CSV feature.

      Jump to:

      Step-by-Step Guide for Updating Prices via CSV Import

      Step 1: Sign into your account here.

      Step 2: Click on [Catalogs] → [View All] and click on the Catalog you wish to update:

      Catalogs > View All as a Supplier

      Step 3: Click the [Exports] tab.

      Step 4: Click on [Create New Export] button on the right, and then confirm the action:

      Create Export File as a Supplier

      Step 5: Once the Status of the Export is Complete, you can click on the Export File Name (in blue) and open the CSV file:

      New Export File as a SupplierStep 6: You now have access to the correct file format that is required for Imports.

      Please update the data in the following 3 columns only:

      • Column A: product_code
      • Column I: pack_price_ex_tax
      • Column J: tax_percentage

      Export File CSV

      Do not edit or delete Column Q (PPID). This unique identifier is essential for PurchasePlus to import the new Prices into your PurchasePlus catalog. If this column is changed or missing, the file will fail to import.

      To avoid errors during the import, clear the contents of Columns M-P, while leaving the headers intact.

      Step 7: Save your updated Catalog as a CSV. Any other format will fail to import.

      Step 8: Return to PurchasePlus. Click [Imports] → [Create New Import]:  


      Create New Import as a Supplier

      Step 9: You will be prompted to provide the following data and selections:
      Import Modal for Suppliers updating pricing by CSV

      • Upload an Import File by either Dragging and Dropping, or clicking the box to browse files on your device.
      • Decide if you wish to Merge With or Replace the entire Catalog. If [Merge] is selected, the Catalog Import will update existing items and add new items, while items already in the Catalog that don't appear in the Import file will remain unchanged. If [Replace] is selected, the Catalog Import will replace the entire Catalog with the items in the Import File - so be sure to let your customers know that you have removed Products from their Catalogs, if that is the case.
      • Schedule Import: Decide here if you would like to schedule the Import at a time and date in the future. If you don't schedule the Import, the import will be actioned immediately. You can refer back to this Catalog at the appointed time and date to confirm that the upload was successful. This feature is very powerful for CPI updates, Limited Time Specials, etc.

      Step 10: Click [Begin Import]. This may take up to 30 seconds or more, depending on the size of the Catalog.

      Step 11: Check the status of the import in [Imports] tab of the Catalog. When its Status is updated to Complete, your new Catalog update has been successfully Imported. The Products in the the Catalog will be available at the updated prices, for any Purchaser(s) to whom the Catalog is assigned.

      Step 12 (Optional): You can click on [View] in the Summary column to view more details about the Import process.

      View More details Import FileTake particular note of the Completion Message, to ensure all lines in the Import File were processed successfully.

      Completion Message Import File

      Troubleshooting & Examples

      In the below example, one Product's PPID is remove, and another Product's details are removed. These lines being 'incomplete' will create problems when we attempt to complete the Import.

      Firstly, the orange colour of the Status 'Complete' tells me the import job has been completed, but there are issues that need our attention to correct and then re-import the file. Let's view our Summary to see what P+ tells us:  Error Complete Import File

      We can see that the Completion Message tells us PurchasePlus tried to import 2 rows of products, but those 2 rows failed.

      Click on the 'Error File' CSV in blue to find the errors.

      Error message import file

      The 'Error File' indicates what is wrong with each line that failed to import.

      In this example:

      • The first line is missing a description. 
      • The second line is missing it's PPID. 

      Error messages IMport File

      Importantly, the existing Catalog is unaffected because of this failed Import. You must correct the missing data, and Import the file again.

      Finding PPID's

      If you are having difficulty confirming (or providing) a PPID for the Catalog import, you can locate PPID's:

      • In the original Catalog export file produced in Step 5 above (which you can re-download in the [Exports] tab of the Catalog if required), and
      • In many places throughout PurchasePlus. For example, on the [Products] tab of the Catalog. Just ensure you have the [P+ Code] option enabled in the Manage Columns feature.

      View PPIDs in Catalog as Supplier

      Update Catalogs via API Integration

      Did you know that PurchasePlus now offers Catalog curation via API Integration?

      Catalog Integration provides a seamless, automated connection between your system and your PurchasePlus account - meaning no more manual updates or spreadsheets!

      Interested? Please reach out to our Head of Supplier Relations, Sandi Tognolini at: sandi.tognolini@marketboomer.com

      Note: Your organisation must have API/EDI integration capabilities to be eligible to use this service.

       

      Additional Support

      Our Supplier Relations team is available for additional support anytime at help.suppliers@marketboomer.com