Price Elements – Key Elements in Price Calculation
To calculate the final product price, the following elements are considered:
- Base Price: This is either the sale price or regular price, as defined by the “Use regular price” option in the Product Price settings.
- Exchange Rate: Configured under the Product Price settings, this can be manually set or automatically updated.
- Shipping Fee: Retrieved during the import process and visible in the Import List.
- Pricing Rule: Pricing adjustments applied based on predefined rules. See option 11 in Product Price documentation for details.
Formulas – How Pricing Rules Are Calculated
There are 3 possible price calculation methods based on when the shipping cost is applied. This is determined by the “Show shipping option” and “Add shipping cost after price rules” settings under the Products tab.
No Shipping Cost
Shipping fee is not included. Only base price, exchange rate, and pricing rules are used.
- “Show shipping option”: Disabled
- Formula: WooCommerce Price = (AliExpress Price * Exchange Rate) + Pricing Rule Adjustment
Shipping Cost Added Before Applying Pricing Rules
Shipping fee is added before pricing rules are applied.
- “Show shipping option”: Enabled
- “Add shipping cost after price rules”: Disabled
- Formula: WooCommerce Price = (AliExpress Price + Shipping Fee) * Exchange Rate + Pricing Rule Adjustment
Shipping Cost Added After Applying Pricing Rules
Shipping fee is added after applying pricing rules to the base price.
- “Show shipping option”: Enabled
- “Add shipping cost after price rules”: Enabled
- Formula: WooCommerce Price = (AliExpress Price + Pricing Rule Adjustment) * Exchange Rate + (Shipping Fee * Exchange Rate)
Examples of Pricing Rule Methods
Let’s take a look at the following example. We’ll break down how each pricing rule method works using the same product data. With the Cost – AliExpress price as below, the applied pricing rule falls under the “Default” range. For consistency, the Sale Price is always $50, and the Regular Price is always $80.
- Cost – AliExpress price: $ 0.99
- Shipping cost: $ 1.99
- Exchange rate: 1
Increase by Percentage
- No Shipping
- Sale price = (AliExpress Price * Exchange Rate) + Pricing Rule Adjustment = 0.99 * 1 + 0.99 * 50% = 1.4849999999999999 ~ 1.49
- Regular price = (AliExpress Price * Exchange Rate) + Pricing Rule Adjustment = 0.99 * 1 + 0.99 * 0.8 = 1.782 ~ 1.79
- Add Shipping Before
- Sale price = (Cost + Shipping Fee) * Exchange Rate + Pricing Rule Adjustment = (0.99+1.99) * 1 + (0.99+1.99) * 50% = 4.47
- Regular price = (Cost + Shipping Fee) * Exchange Rate + Pricing Rule Adjustment = (0.99+1.99) * 1 + (0.99+1.99) * 80% = 5.364 ~ 5.36
- Add Shipping After
- Sale price = (Cost + Pricing Rule Adjustment) * Exchange Rate + (Shipping Fee * Exchange Rate) = (0.99+0.99*0.5) * 1 + (1.99*1) = 3.4749999999999996 ~ 3.48
- Regular price = (Cost + Pricing Rule Adjustment) * Exchange Rate + (Shipping Fee * Exchange Rate) = (0.99+0.99*0.8) * 1 + (1.99*1) = 3.7720000000000002 ~ 3.77
Increase by Fixed Amount
- No Shipping
- Sale price = (Cost * Exchange Rate) + Pricing Rule Adjustment = 0.99 * 1 + 50 =50.99
- Regular price = (Cost * Exchange Rate) + Pricing Rule Adjustment = 0.99 * 1 + 80 =80.99
- Add Shipping Before
- Sale price = (Cost + Shipping Fee) * Exchange Rate + Pricing Rule Adjustment = (0.99+1.99) * 1 +50 = 0.99 + 1.99 +50 = 52.98
- Regular price = (Cost + Shipping Fee) * Exchange Rate + Pricing Rule Adjustment = (0.99+1.99) * 1 +80 = 0.99 + 1.99 +80 = 82.98
- Add Shipping After
- Sale price = (Cost + Pricing Rule Adjustment) * Exchange Rate + (Shipping Fee * Exchange Rate) = 0.99 + 50 + 1.99 = 52.98
- Regular price = (Cost + Pricing Rule Adjustment) * Exchange Rate + (Shipping Fee * Exchange Rate) = 0.99 + 80 + 1.99 = 82.98
Multiply by Value
- No Shipping
- Sale price = (Cost + Shipping Fee) * Exchange Rate * 50 = 0.99 * 50 = 49.5
- Regular price = (Cost + Shipping Fee) * Exchange Rate * 80 = 0.99 * 80 = 79.2
- Add Shipping Before
- Sale price = (Cost + Shipping Fee) * Exchange Rate + Pricing Rule Adjustment = (0.99+1.99) * 1 * 50 = 149
- Regular price = (Cost + Shipping Fee) * Exchange Rate + Pricing Rule Adjustment = (0.99+1.99) * 1 * 80 = 238.4
- Add Shipping After
- Sale price = (Cost + Pricing Rule Adjustment) * Exchange Rate + (Shipping Fee * Exchange Rate) = 0.99*50*1 + 1.99*1 = 51.49
- Regular price = (Cost + Pricing Rule Adjustment) * Exchange Rate + (Shipping Fee * Exchange Rate) = 0.99*50*1 + 1.99*1 = 81.19
Set to Specific Value
- No Shipping
- Sale price = 50
- Regular price = 80
- Add Shipping Before
- Sale price = 50
- Regular price = 80
- Add Shipping After
- Sale price = (Cost + Pricing Rule Adjustment) * Exchange Rate + (Shipping Fee * Exchange Rate) = 50 + 1.99 = 51.99
- Regular price = (Cost + Pricing Rule Adjustment) * Exchange Rate + (Shipping Fee * Exchange Rate) = 80 + 1.99 = 81.99