Basic Guide to Pricing Feed
This guide provides a comprehensive overview of how to manage pricing feeds within the UpStart Commerce Portal. By following these steps, businesses can effectively update and manage their pricing information, ensuring accurate and optimized price calculations across different zones and currencies.
To update the Pricing Feed, specific roles, and permissions are required. For more information on the necessary roles, please refer to the System Defined Roles guide.
Upon logging in, navigate to the side menu of the UpStart Commerce Portal, go to Pricing Feed, and then click Pricing Feed Listing.
Open your preferred spreadsheet software (Word Pad Google Sheets, LibreOffice Calc, etc.). Open a new, blank spreadsheet document.
In the first row, add the following column headers. These headers define the fields you need to fill in for each price entry:
- ASSET_ID*: The unique identifier for the asset.
- ZONE*: The geographic pricing zone.
- CURRENCY*: The three-character ISO currency code (e.g., USD for US Dollars, EUR for Euros).
- PRICE TYPE*: The type of price sale, MSRP, and list price.
- PRICE*: The standard price.
- SALES PRICE START: The start date of the sales price. (e.g 2024-10-12)
- SALES PRICE END: The end date of the sales price. (e.g 2024-10-15)
- TAG OF SALES PRICE: The tag or label for the sales price.
NOTE: Fields marked with an asterisk (*) are Mandatory, while others are Optional.
After adding the column headers, save the file as a CSV (Comma-Separated Values) file. This format ensures that the data is correctly formatted for upload.
For more information on CSV File Attributes, go to the File Attributes guide.
Starting from the second row, enter the data for each price entry. Each column should contain specific information as per the headers.
After entering all the data, SAVE the file as a CSV (Comma-Separated Values) file to ensure that the data is correctly formatted for upload.
Ensure that each field is separated by a COMMA. This is crucial for maintaining the structure of the CSV file.
After completing the CSV File with all the required details, return to the UpStart Commerce Portal. Click on the Upload Arrow Button button at the top-right corner of your screen to initiate the upload process. Select the completed CSV file from your system and proceed with the upload.
In this step, you can track the progress of your file upload and view detailed information about the processed feed.
- Once you've uploaded your CSV file, the system will begin processing it. The import time may vary depending on the file size and complexity of your data.
- During the upload process, you'll see various states displayed on-screen starting from SCANNING to PROCESSED. These represent different stages of the import process. For a detailed explanation of states, refer to the Price Feed File Status guide.
Click on the ACTION icon to fetch the latest state and details regarding your file.
To view the details of the uploaded feed, click on the Feed ID highlighted in the above image. You will see all the details of the pricing-feed file, such as the total number of assets, processing time, feed status, and any error details. Below you can see that the feed is successfully processed into the system. In case of an error, go to the step 5.
In this step, you can identify and resolve any errors that occurred during the processing of your file. This ensures that your data is accurate and error-free before finalizing the updates.
First, let's identify errors. If the system shows any errors during processing, proceed to review the errors provided by the system. The screenshot below shows that the file is processed but it contains errors. To view the errors in detail, click on the Feed ID. This will list all the errors your file contains.
After clicking feed ID, you will see the errors in the example below that there is duplication for the same Asset ID.
After reviewing the detailed error information, open your CSV file to resolve the errors. Update any missing information, remove duplicates, and ensure all information and syntax are accurate. Once corrected, re-upload only the corrected SKU information to the UpStart Commerce Pricing Feed. This approach minimizes processing time. However, if you re-upload the entire file, please note that it will require additional processing time. By focusing on the specific SKUs with errors, you will efficiently ensure your pricing feed's accuracy and up-to-date information.
By following this comprehensive guide, you can effectively manage and update your pricing feeds within the UpStart Commerce Portal. Accurate and timely updates ensure consistency in pricing information across all zones and currencies, enabling optimized price calculations and maintaining competitive positioning.