Managing Wholesale Prices with CSV Files

The Wholesale Gorilla app allows you to export a .csv file of your products and their wholesale prices. You can export either a specific price list based on a tag or all products in your catalog. This CSV file can then be modified and re-imported to update wholesale prices efficiently.

You can now manage wholesale prices via CSV, allowing for quick and efficient management of discount rules, by following 3 steps:

1. export a .csv file of your wholesale price rules or your product catalog through our app.
   • Important!: to use our feature, you must export your product list through Wholesale Gorilla, and not through Shopify.
2. edit the .csv file to quickly set up price rules or percentage discounts for your product's variants.
3. import your edited .csv file back into Wholesale Gorilla 

To successfully utilize this CSV feature, merchants should be familiar with wholesale discount rules and be comfortable with working with .csv files. For detailed information, please refer to the Wholesale Discount Rules Guide.

Exporting a Wholesale Price List

To export a .csv file of a price list based on a tag:

1. Open the Wholesale Gorilla app and navigate to Price rules & discounts.
2. Locate the Wholesale price list card at the top of the page and click Manage prices to access the price list index.
3. Click Export.
4. Select Price rules by tag, then choose the tag corresponding to the price list you want to export.
5. Choose the Price field option:
   • With wholesale prices: Exports current wholesale prices.
   • With blank wholesale price field: Exports products without prices, allowing you to enter new ones.
6. Click Export to download your .csv file.

Exporting All Products

To export a .csv file of your entire product catalog:

1. Follow steps 1-5 above.
2. Select All products.
3. (Optional) Check the boxes to include draft products and/or archived products.
4. Click Export to download your .csv file.

This .csv file will contain all products with a blank wholesale price field, allowing you to input and update wholesale prices before re-importing.

Importing a price list via a .csv file

To upload a price list, follow these steps:

1. Select or Create a Price List: Choose the existing price list you wish to import to, or create a new price list and assign a customer tag for it.
2. Start the Import Process: Click on the “Import” button.
3. Upload Your CSV: You can either drag and drop your .csv file into the designated area, or click “Add file” to browse and select the file from your computer.
4. Choose Import Options:
   • Append and Replace: This option will add new price rules to the existing price list. Any duplicate rules in the file will overwrite the current ones.
   • Delete All Price Rules: This will remove all existing price rules and replace them with the new data from your CSV file.
5. Click Upload.
6. You'll be prompted to verify that price rules look correct.  Once verified, click Import prices.

Editing price rules

WARNING!  Please read carefully!

In order to ensure proper functionality, the following rules must be followed:

• The only column you should edit is the Wholesale Price column.  No other values should be altered in any way.
• Do not remove or rename any columns from the csv file. Doing so will break the feature.

Once you have successfully exported your price rules into a CSV file, follow these steps to edit them.

1. Open the .csv file

   • Open the .csv file in an environment that does not automatically convert the data. Popular options include Microsoft Excel, Google Sheets, or a plain text editor.
   • Important: When importing the .csv file, ensure that any option to convert data is disabled. This will prevent any automatic formatting that could alter your data.

2. Editing the wholesale price column

   • Locate the column labeled Wholesale Price in your .csv file. This is the only column you need to edit for updating price rules.
   • Set a Fixed Price: To set a fixed wholesale price for a variant, enter the amount as a number. For example, if you want the price to be six hundred twenty-three dollars and five cents, enter 623.05.
   • Set a Percentage Discount: To apply a percentage discount to a variant, enter the discount percentage followed by the percent symbol (%). For example, if you want to apply a 12% discount, enter 12% in the Wholesale Price column.

3. Basic CSV Editing Instructions:

   • Open Your Editor:
     • For Microsoft Excel: Open Excel and select File > Open, then choose your CSV file.
     • For Google Sheets: Open Google Sheets, select File > Import, then upload your .csv file.
     • For a plain text editor: Open the editor and drag the CSV file into the workspace or use the Open function to locate and open the file.
   • Make the Necessary Changes:
     • Locate and edit the Wholesale Price column as described above.
   • Save and Export the Edited CSV:
     • For Microsoft Excel: Once you have made your changes, go to File > Save As, and select CSV (Comma delimited) from the list of file types.
     • For Google Sheets: After making your changes, select File > Download > Comma-separated values (.csv, current sheet).
     • For a plain text editor: Save the file ensuring it remains in CSV format.

By following these steps, you can accurately edit your price rules without any unintended data conversion, ensuring the integrity of your pricing strategy.

Important!

When using the CSV import/export feature for price rules, some spreadsheet editors may automatically reformat large numbers in the ID column as scientific notation. For example, an ID like 10034585495643 may appear as 1E13, which can lead to errors during import. To prevent this, ensure that the ID column is set to “Text” format in your editor before saving the file. This keeps the ID as a multi-digit number and prevents it from converting to scientific notation. If you’re using Excel, you can select the entire ID column, right-click, choose Format Cells, and select Text to lock the formatting.

By leveraging these features, you can efficiently manage and update your wholesale price rules. For further assistance, please contact our support team.