QuickEdit is the most effective tool to visualize, export, and edit product information across your catalog. As such, it is a great way to manage your pricing both in bulk and on a granular level.
- The Basics
- Audit Min and Max Pricing
- Manage Channel Pricing Overrides
- Pricing Across Different Catalog Segments
- Make Bulk Changes
The Basics of QuickEdit and Pricing
In QuickEdit you can add any number of product fields to your view simply by clicking on the "Add Column" button on the right side. This pops up a box where you can search all the product fields in Zentail. (Check out our Data Dictionary for a reference of all the fields and their types.)
The most helpful fields to manage your pricing are:
- Item Price
- Min Price
- Max Price
- Channel Price Overrides (more on these below)
By default the base QuickEdit view already includes the cost field, which is helpful to fill in for your products to ensure your Analytics is more accurate, and so that you can more appropriately set your minimum price.
How to Audit Min and Max Prices Using QuickEdit
If you have enabled the repricer for Amazon and/or Walmart, filling in your Min Price and Max Price will begin repricing your SKUs for those channels. Conversely, if you have enabled the repricer for one of those channels and do not want to reprice select SKUs, removing the minimum or maximum price will halt the repricer. To audit what SKUs have values filled in for the Min Price or the Max Price, it's helpful to use the "Blank" filter:
This will filter for all SKUs that do not have a Max Price filled in. If you wanted to filter for SKUs that do have a maximum price you can simply check "Negate" and that will filter for all SKUs with a value in the maximum price field.
You can also filter for SKUs that are greater than or less than a certain price, or between two prices. Learn more about setting up filters in QuickEdit here.
Using QuickEdit to Manage Channel Price Overrides
You can set price overrides for specific SKUs on specific channels. For instance perhaps you want your webstore price to be slightly higher than your Amazon price, using a channel price override is a good way to ensure that. You can view, set, edit or remove your price overrides in QuickEdit. All you need to do is add the field "<Your integration name> (Channel) Price Override. Its usually easiest to just search "Channel Price Override" and then select the integration you are interested in like so:
Once you have this field added, it's easy to edit it directly in the QuickEdit view.
Using QuickEdit to Audit Products Across Different Segments
The most powerful part of QuickEdit is the ability to combine and filter across multiple fields. If you know you want to audit or change your pricing across an entire brand you can add the field for Brand and then filter on it. If you only want to adjust your pricing for your SKUs that are listed to Amazon you can add that field and filter on it. QuickEdit provides a nearly limitless way to segment your catalog to your taste. If the segment you want to view isn't easily captured through filtering on product data elements, think about adding your own custom labels to your SKUs to easily identify them!
Making Bulk Changes with QuickEdit
There are two ways to make bulk changes to your catalog:
- Importing Data
- Bulk Actions
QuickEdit facilitates both of those options with the "Export View" and "Create Bulk Action" buttons:
If you "Export View" Zentail will export the columns you have included in the QuickEdit view along with any filters you have applied. You can download that export on the Import / Export page under "previous exports". This allows you to keep a record of what the data was before you make any changes. You can then edit that csv in Excel or other spreadsheet editor software and then import the changes back into Zentail. (Tip: If you keep the column headers the same you can easily use the "Templateless Product Data Import" option. Learn more here!) There are some columns that are exportable only, so double check the Zentail's Data Dictionary if you are having trouble importing your data.
If you "Create Bulk Action" you will be redirected to our Bulk Actions page with whatever filters you have already in place on QuickEdit automatically applied. In the Bulk Actions page you can do a number of things, but most relevantly for pricing you can "Set Value". This allows you to set or change your prices in bulk, even according to a formula. For instance you could set your Min Price to be x times your Cost, and then set your Max Price to be y times your Min Price. Learn more about Bulk Actions here!