Auto Price
Feature Overview
SP supports an automated pricing mechanism through price templates. Users can: designate a source store as the price reference. And define adjustment rules (e.g., markups, discounts, fixed values). The system will automatically apply these rules and sync adjusted prices to target stores, ensuring consistency across multiple channels and streamlining operational efficiency.
How to Use Auto Price
Access Product > Product Management > Auto Price
Page Introduction
Introduction to Search Bar Fields
| Field | Description | Remarks |
|---|---|---|
| Product Name | Product title, supporting fuzzy search | None |
| SP SKU | The product code within SP, which is unique | None |
| Source Store | Refers to the store whose product prices are used as a reference when the system executes price adjustment rules. That is, SP will obtain the daily selling price of the SKU from the source store as the basis for price adjustment | None |
| Target Store | Refers to the store where the price adjustment rules are applied and prices are updated. The system will automatically calculate and update the selling price of the corresponding SKU in the target store based on the price of the source store and the set price adjustment rules | None |
| Sync Type | Same: The price remains unchanged, consistent with the SKU price of the source store. Percentage: The SKU price of the target store is calculated by increasing/decreasing the source store's price by a certain percentage. Fixed value: The SKU price of the target store is calculated by increasing/decreasing the source store's price by a certain fixed amount | Filter condition |
| Change Type | Increase/Decrease: The SKU price of the target store is calculated by increasing/decreasing the source store's price | Filter condition |
| Price Type | The current price type is the product's selling price | Cart price coming soon |
| Status | Indicates whether the price rule is in use | None |
Introduction to Fields in the Rule List
| Field | Description | Remarks |
|---|---|---|
| Commodity | Product pictures, titles and SP SKUs will be displayed here | None |
| Source Store | The channel, store, current price, store SKU and product ID where the product is located will be displayed here | None |
| Target Store | The channel, store and product ID where the product is located will be displayed here | If the product ID is missing, please check whether the product is in draft status |
| Rule | The price rule is increase/decrease | None |
| Base Price | The current price type is the selling price of the product | Cart price coming soon |
| Status | The usage status of this rule | None |
| Operation | Enable: Activate the rule. Delete: Remove this price rule from SP. Edit Rule: Edit and modify the price rule. Synchronize Price: Manually trigger price synchronization according to this rule | None |
Step 1: Create a rule
-
When users use the migration function, they can also create price rules on the page for setting prices and inventory. For details, please [refer here].Please refer to Store Migration
-
Click Products > Product Management > Auto Price, then click Add Auto Price, and set the price adjustment rules.
Step 2: Set up the rule
Set via SKU#
-
Select the source store and target store. Please first confirm that the store authorization has been completed. How to authorize the store?
-
Enter the SP SKU of the product. If there are multiple SKUs, separate them by line breaks. If there are multiple SKUs, the same price synchronization rule will be set for all of them.
Instructions for Price Synchronization Settings
| Field | Description | Remarks |
|---|---|---|
| Synchronization Type | The selling price of the corresponding SKU | None |
| Synchronization Type | Same: The price remains unchanged, consistent with the selling price of the SKU in the source store Percentage: Calculate the selling price of the SKU in the target store by increasing/decreasing the selling price of the source store by a certain percentage Fixed value: Calculate the selling price of the SKU in the target store by increasing/decreasing the selling price of the source store by a certain fixed amount |
None |
| Base Price | The current price type is the selling price of the product | Cart price coming soon |
| Duplicate Rule | If a price rule for the SKU already exists in the system when creating a price rule, and the source store and target store are also the same: Skip: Keep the existing rule and do not create a new one Overwrite: Replace the existing price rule with the new one |
It is not allowed to create different price rules for the same SKU when the source store and target store are consistent |
| Price Rounding | The system can automatically round the final target price to end with .99 | Only available when the synchronization type is percentage |
Note: After submitting for creation, please do not close this page. The results will be displayed once the creation is completed. If there are any error reports, please check and modify according to the error prompts.
Setting via Excel
Select the source store and target store. Please first confirm that the store authorization has been completed How to authorize the store?
Download the template and fill in the following information.
| Field | Description | Remarks |
|---|---|---|
| SKU | The code of the product in the SP system, i.e., SP SKU | |
| Sync Type | Same: The price remains unchanged, consistent with the selling price of the SKU in the source store Percentage: Calculate the selling price of the SKU in the target store by increasing/decreasing the selling price of the source store by a certain percentage Fixed: Calculate the selling price of the SKU in the target store by increasing/decreasing the selling price of the source store by a certain fixed amount |
If "Same" is selected here, the subsequent "Change Type" should be left blank |
| Change Type | Increase: To raise. Decrease: To lower |
Required if "Sync Type" is set to "Percentage" or "Fixed" |
| Amount | The value to be increased or decreased | Required if "Sync Type" is set to "Percentage" or "Fixed" |
| SourceItemID | Source product, which requires the product ID Please go to the listing management list to check the product ID |
For products in the total product list, if the product status in listing management is "Draft", there is no product ID, and this field can be left blank |
| TargetItemID | Target product, which requires the product ID Please go to the listing management list to check the product ID |
For products in the total product list, if the product status in listing management is "Draft", there is no product ID, and this field can be left blank |
| For Duplicated Rule | If a price rule for the SKU already exists in the system when creating a price rule, and the source store and target store are also the same: Skip: Keep the existing rule and do not create a new one Overwrite: Replace the existing price rule with the new one |
It is not allowed to create different price rules for the same SKU when the source store and target store are consistent |
| Price Rounding | The final target selling price will be automatically adjusted by the system to end with .99. For example, if the calculated target selling price is 5.21, the system will automatically update it to 5.99 for synchronization On: Enable this setting to make the price end with .99 Off: Synchronize with the actual calculated target selling price |
None |
After filling in and saving, click Upload File on the page to upload and create.
Note: After submitting for creation, please do not close this page. The results will be displayed once the creation is completed. If there are any error reports, please check and modify according to the error prompts.
Step 3: Execute the rule
When a rule is created or after a rule is edited, the system will automatically trigger price synchronization; if synchronization fails, you can also manually trigger the price synchronization operation.