We’ve made it easy to batch in your pricing! Choose the Excel Pricing Updater from your My Plants library. Download the Excel file, add your pricing, and save your file. Upload it back in and all your pricing is updated! Easy!
The following fields are available for UPDATING. This system does NOT create new plant records.
COLUMN | INITIAL VALUE/CONTENT | DESCRIPTION |
SKU | Null | System will generate a barcode based on this field. NOTE: Only select bench cards, tags and labels display a barcode. |
PRIMARYNAME | System Generated | The 'title' of the plant bench card. |
SECONDARYNAME | System Generated | The 'sub-title' of the plant bench card. |
SIZE | Null | The size of the plant you are selling. |
PRICE | Null | The price of the plant you are selling. |
SALEPRICE | Null | If applicable, enter the sale price. NOTE: Only select bench cards and hang tags display the sale price. |
PLANTTYPE | System Generated | This is for plant category like Annual, Perennial, Shrub and Tree. |
ORDERQTY | Null | This is the number of signs you want to order or download for each particular plant record. |
FEATUREONWEBSITE | No (= 0) | If we are building your website, we use this value (0 = No and 1 = Yes) to know if the plant should be featured on your home page. |
DISPLAYONWEBSITE | Yes (=1) | If we are building your website, we use this value (0 = No and 1 = Yes) to know if the plant should be displayed on your website. |
SELLABLEONWEBSITE | Yes (=1) | If we are building your E-commerce website, we use this value (0 = No and 1 = Yes) to know if the plant should be sellable on your website. |
QRCODEURL | Null OR System Generated | If we are building your website, we will prepopulate this field with the proper URL. If not, it will be null. |
SKUTWO | Null | Only applicable with a multi-size,multi-price template. |
SIZETWO | Null | Only applicable with a multi-size,multi-price template. |
PRICETWO | Null | Only applicable with a multi-size,multi-price template. |
SALEPRICETWO | Null | Only applicable with a multi-size,multi-price template. |
SKUTHREE | Null | Only applicable with a multi-size,multi-price template. |
SIZETHREE | Null | Only applicable with a multi-size,multi-price template. |
PRICETHREE | Null | Only applicable with a multi-size,multi-price template. |
SALEPRICETHREE | Null | Only applicable with a multi-size,multi-price template. |
DONOTEDIT | System Generated | Do NOT change the values in this column. |
IGNORE1 | Null | Ignore |
IGNORE2 | Null | Ignore |