Basic Guide to Pricing Feeds

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 key concepts docid 6nalbgudon6kiyrztjqdh guide step 1 access pricing feeds upon logging in, navigate to the side menu of the upstart commerce portal, go to pricing feed , and then click pricing feed listing step 2 create and fill the csv file 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 key concepts docid\ qpqjdqfik xlaqvnkwahf guide starting from the second row, enter the data for each price entry each column should contain specific information as per the headers asset id,zone,currency,price type,price,sales price start,sales price end,tag of sales price dc bn642mon,"texas",usd,listprices,24,,, dc bn642mon,"texas",usd,msrpprices,39,,, dc bn642mon,"texas",usd,saleprices,23,2023 10 03,2023 10 12,"epic fall sale" 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 step 3 upload 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 step 4 monitor and track file status in this step, you can track the progress of your file upload and view detailed information about the processed feed track the upload process 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 key concepts docid\ qpqjdqfik xlaqvnkwahf guide click on the action icon to fetch the latest state and details regarding your file view feed details 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 step 5 resolve errors 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 identify errors 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 correct errors 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