Exporting & Importing Detailed Product Pricing
To access the PRODUCTS screen: Go to the PRODUCT MASTER menu → PRODUCTS screen
Dynamic Pricing Summary:
If your account has Dynamic Pricing enabled, you will be able to enter & view additional price/cost fields on products as well as export this information in excel format. Changes can be made and bulk uploaded back into Seedtrakr.
Exporting & Editing Detailed Product Pricing
On the PRODUCTS page, click the Download button. In the list of options that appears, click Detailed Product Pricing (Excel).
In the excel file that downloads, you can update the information in any of the blue fields.
Purchase Price: The price the inventory was purchased for.
Grower Premium: The grower premium for the product (per UoM).
Royalty: The royalty amount for the product (per product UoM).
Cleaning: The cleaning cost for the product (per product UoM).
Target Margin: The target margin (%) for the product.
Base Margin: The base margin (%) for the product.
Target Commission: The target commission (%) for the product.
Update SRP from COGS: This specifies whether or not the product SRP will be updated based on the cost of goods sold. Enter Y if you want the SRP to be automatically updated based on the information entered in the spreadsheet, if you don't want it to be updated, enter N.
Save the excel file.
Importing Detailed Product Pricing
On the PRODUCTS page, click the Import Detailed Pricing button.
The IMPORT DETAILED PRICING screen will now appear. Click Attach to select the modified pricing file that you want to upload.
Click Add on the attachments page.
Then click Choose File button to select the file from your computer that you want to use to upload the prices.
Once the file has been selected, click Attach, then click Close to exit the dialog.
You will be redirected back to the Import Product Pricing screen, here you will see the file you uploaded appear under the Product Lists title.
Click the ▶️ button beside the product list you want to import.
The file will be checked to ensure it is formatted correctly and can be imported, once complete a summary of all the products and their information will be shown.
If all the information looks good, scroll to the bottom of the page and click Complete Import.
Once the upload has been successfully completed, you will receive a message in the bottom right corner of the page indicating how many products were imported.
Now, if you check the products page the changes you made to the products will be reflected on the products there.