Key Concepts

this section provides a foundational overview of key concepts essential to the pricing feed system within upstart commerce these concepts are the fundamental building blocks that enable businesses to manage and optimize their pricing processes effectively by understanding these core elements, businesses can ensure accurate price calculations, manage different prices across pricing zones, and streamline operations, saving time and reducing the risk of errors pricing vs pricing feed? pricing is the fundamental service responsible for managing all product pricing however, updating a single field within the pricing service can be time intensive, necessitating updates across all related fields, and resulting in slow response times in response to these challenges, we have introduced pricing feed as an advanced feature designed to streamline and expedite data updates pricing feed facilitates quicker updates by allowing users to upload files containing pricing data this approach significantly simplifies the implementation process, reduces the time required for updates, and enhances overall responsiveness types of prices in the upstart commerce portal, we manage three primary types of prices sale price, manufacturer’s suggested retail price (msrp), and list price each type serves a specific role in defining our pricing strategy understanding these distinctions is crucial for effective price management and optimization our prices are as follows sale price the sale price is the discounted rate at which a product is offered during a promotional period this temporary price reduction aims to boost sales and attract customers by offering a perceived value deal msrp price the manufacturer's suggested retail price (msrp) is the price recommended by the manufacturer for retail sales it serves as a guideline for retailers, helping to standardize pricing across different sellers list price the list price is the standard price set by the retailer, serving as the baseline before any discounts or promotions are applied it provides a reference point for customers and helps in calculating discounts and promotional prices what is a csv file? a csv (comma separated values) file is a simple text file used to store tabular data each line in the csv file represents a single record, and each field within a record is separated by a comma csv files are commonly used for data exchange between different applications because they are easy to read and write to update the data in the pricing feed, you will use a csv file first, you will create a csv file , then store the pricing data in the following format 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" note the first row in the pricing feed file is always ignored as headers csv file attributes for pricing feed when preparing a csv file for the pricing feed, it is essential to comprehend each attribute thoroughly due to its significance in accurate pricing management the key attributes include asset id this attribute specifies a unique identifier assigned to each sku within your system it serves as a consistent reference point for identifying and managing products across various platforms and operations for example, dl abcde could be the asset id for a specific model of laptop zone the zone attribute allows you to define specific geographical areas where your pricing strategy applies this can include cities, states, or any other market segments you define for instance, texas and new york could be designated zones where different pricing strategies are implemented to account for local market conditions currency specify the currency in which the product price is denominated this attribute is crucial for international businesses to reflect pricing in different global markets accurately for example, usd denotes u s dollars, eur denotes euros, and so on you will use the iso alphabetic currency code to specify the currency to see how iso specifies currency codes, go to the iso currency code guide price type this attribute defines the type of pricing for the product, such as sales, msrp (manufacturer's suggested retail price), or list price it distinguishes between different pricing strategies to suit various business needs for example, use 'saleprices' for promotional pricing and 'msrpprices' for the manufacturer's suggested retail price the allowed values for price type are 'saleprices,' 'listprices,' and 'msrpprices ' price specify the numerical value of the product's price this field ensures clarity and consistency in pricing across all products, helping customers and stakeholders understand the cost of your offerings for example, a product priced at 500 dollars sales price start optionally, specify the start date for any sale pricing this field allows you to automate price changes at specific times, such as during seasonal promotions or marketing campaigns for example, you will specify the sales price start date in the format yyyy//mm/dd (e g , 2023 10 03) sales price end optionally, specify the end date for any sale pricing this field complements the start date, ensuring that promotional pricing changes automatically revert to regular pricing (list price) after the specified period for example, you will specify the sales price end date in the format yyyy//mm/dd (e g , 2023 10 05) note after adding a start date, it is mandatory to specify an end date for the sales price; otherwise, the system will prompt an error missing date pricing feeds file status when you upload the csv file in the pricing feed, you will see the following statuses on the screen scanning the file has been received and scanned for initial validation for example, when you upload a csv file, the system scans it for proper format and structure scanned the file has been successfully scanned and is ready for further processing for instance, after the scanning phase, the system confirms that the file is structured correctly and moves to the next stage importing the file is currently being imported into the system for example, the data from the file is being loaded into the upstart commerce database imported the file has been successfully imported, and the data is now in the system for instance, the product prices from the file are now available in the system for further action processing the imported data is being processed for example, the system is now updating the prices of products based on the imported data processed when a file reaches the processed state in the pricing feed cycle, it indicates that the system has completed its evaluation during this phase, the system thoroughly reviews the file, applies any necessary updates, and checks for errors fields containing valid data are processed and updated in the feed without issues however, if any fields within the file contain errors, the system will flag them in such cases, the file is partially processed valid data is updated, while some erroneous data requires further attention you will address the errors and re upload the erroneous fields to the pricing feed error when a file reaches the error state in the pricing feed cycle, it signifies that none of the fields were processed successfully this status indicates that the file contains errors, preventing the successful completion of the process to proceed, you must address the errors, correct the data, and re upload the file