Update price list connector is used to carry out massive updating activities on prices, applying discounts or increases on the same price list or on new lists created ad hoc.

The possible applications are many, for example:

  • Apply a 30% discount on all products of the last season
  • Populate a new price list with a 20% price increase to be adopted in a new store dedicated to a market with higher price standards
  • Populate a new dedicated price list with 50% discounted amounts for a reseller site
  • Calculate amounts with currencies other than the original one

We remind you that the price structure managed by bindCommerce provides for infinite price lists, and on each list price the indication of multiple prices:

  • Net price (excluding VAT)
  • Gross price (including VAT)
  • Discounted price
  • Discount Price Application: Disabled - Replaces the net price (excluding VAT) - Replaces the gross price (including VAT)

Let's see in detail how to create a configuration to recalculate the list prices, and the relative connector.

Price rules

thumb price processing

To create the price recalculation configuration go to the menu

Process >> Processing configuration >> Price rules

Click on Add at the top left to create a new configuration, choose the name and click on SAVE AND CONTINUE to access the following fields.

The configuration will insert or update the calculated list prices (list price or discounted price) starting from a starting price list, applying one of the following formulas:

  • Price List calculated = [multiplier] x Starting price list + [constant]

or

  • Calculated Discounted Price = [multiplier] x Starting price list + [constant]

You then need to select below:

  • Element to be calculated: choice between List Price or Discounted Price
  • How to use the discounted price: The same as the starting price list - Disabled - Consider the price including VAT - Consider the price excluding VAT
  • Calculated price list: the price list on which the already recalculated price will be saved
  • Starting price list: the price list that contains the original cost that will be considered as the starting price for the recalculation
  • Starting price: VAT included or VAT excluded. On the basis of the indicated value, the price recalculation will take place either on the gross price or on the net price.

and numerical values:

  • Multiplier: The multiplier is a decimal number. For example, if we intend to increase the prices by 20% compared to the starting price list, you must enter the value 1.2 To decrease the prices by 33% we can enter the value 0.67
  • Constant: The constant is a positive (to add a constant value) or negative (to deduct a constant value) decimal number.
  • Multiplier from an attribute: allows you to take the multiplier from an attribute instead of the default field, which in this case will be ignored
  • Valid from - Until: duration that can be set for the discount period. The data is sent to the connected platform and after the date the discount is deactivated
  • Use VAT rate: specify whether to take VAT from the base price list or to enter a custom value
  • Also add the shipping cost: if specified in the price list, any shipping cost can be added to the processed price
  • Do you also consider child products ?: by activating the option, the calculation is not applied only to the parent or main products, but also to any variants
  • Rounding: rounding allows you to define the specific calculation more precisely. It is possible to round to the second decimal, the first or the whole value.

Click on SAVE AND CLOSE.

Connector execution

When the configuration is complete go to the menu

Process >> Connectors

click on Add at the top left and fill in the fields as follows:

  • Name
  • Node type: bindCommerce
  • Node: the node created earlier
  • Connector type: Data processing [Price generation]

Click on SAVE AND CONTINUE to access the following fields.

  • Configuration: select the previously created configuration
  • Product filter: select a previously created filter. It is recommended to always use a filter for this type of process, as it will be necessary to indicate to the connector which items to consider for the execution of the process. If no filter is indicated on the products, they will all be considered in the price recalculation phase. For the creation of a product filter, please refer to the appropriate tutorial.

Click on SAVE AND CLOSE. The connector can be performed within an automatic procedure, or manually.

5 of 5 - 1 votes
Thank you for rating this article.

Tutorials

bindCommerce platform
Nodes
Creating a Web Server node to publish images
Connectors
Procedures
Logs
Products
Categories
Product attributes
Price lists and prices
Manufacturers
Alternative descriptions
Payment and shipping methods
Orders
Customers
Filter setting on products
Filter setting on orders
Multi warehouse
Differential approach
Internal processing
How to use templates
Template gallery
Creation and customization of templates
Responsive photo gallery in eBay description
Creation and activation of a connector to create/update alternative descriptions
Match categories
Update Price List
Dynamic currency conversion
Internal processing script
Attribute enrichment script
Barcode type calculation
Generation of derived products
Order transformation
Quantity rules
Distribution grid
Conversions and normalizations
Conversions
Currency conversion
Order status normalization
SKU recoding
Marketplaces
eBay integration
eBay nodes installation
Matching with eBay categories
Sales terms
Parameters for listing generation
eBay listing generation
Download listings from eBay
Fixed price sale or auction
eBay listing details list
Listing update
Early ending of listings
Relisting
Responses from eBay and related logs
The automated workflow
Download orders from eBay
Download categories from the eBay shop and match with product categories
Matching of eBay categories international markets
Copy Manufacturer and MPN to Attributes
Amazon integration
Amazon node
PRE-SALE ACTIVITIES
Amazon listings and details
Creation and publication of products/offers to Amazon
Set up Amazon shipping templates
Products already on Amazon
Parameters configuration for preparing Amazon offers
Amazon offers generation connector
Creation of products already present on Amazon
New products publishing
Parameters configuration for preparing Amazon offers
Creation of products not present on Amazon
Amazon offers generation connector
Matches with Amazon categories
Selling on Amazon: Attributes tutorial
Clothing category tutorial
Shoes category tutorial
Responses from Amazon and related Logs
AFTER-SALES ACTIVITIES
Download orders from Amazon
Order status update from bindCommerce
Amazon Business integration
PRE-SALES ACTIVITIES
B2B prices
VAT classification
Discounts for quantities
AFTER-SALES ACTIVITIES
Amazon Business order download
Billing management
Upload invoices issued by Danea
Download invoices on Danea
Transfer of invoices issued by Amazon to Danea
Delivery preferences
ePrice integration
ePrice listings preparation
ePrice node installation
Sending ePrice listings
Download ePrice orders
Creation of sample product files
Orders update to ePrice
ManoMano integration
ManoMano nodes installation
Send listings to ManoMano
Download orders from ManoMano
cDiscount integration
Category matching
Shipping methods mapping
Cdiscount node
Couriers mapping
Publishing new products on cDiscount
Publication of offers on Cdiscount
Import orders from Cdiscount
Cdiscount problem fixing
Allegro integration
Allegro node installation and configuration
Create Allegro Category Matches
Publishing products on Allegro
Product update on Allegro
Import orders from Allegro
AliExpress integration
AliExpress node installation
AliExpress category matching
Publishing products on AliExpress
Product groups and AliExpress brands
Download orders from AliExpress
Wish integration
Wish node installation
Publishing products on Wish
Carrier mapping for Wish
Download orders from Wish
Order update on Wish
Zalando integration
CONNECTED RETAIL
Zalando node installation (CR)
Offers management on Zalando (CR)
Import orders from Zalando (CR)
Leroy Merlin integration
Leroy Merlin node installation
Leroy Merlin pairing categories
Export products on Leroy Merlin
Offers publication on Leroy Merlin
Offers update on Leroy Merlin
Delete products/offers on Leroy Merlin
Downloading orders from Leroy Merlin
Orders update on Leroy Merlin
Conrad integration
Conrad node installation
Conrad category matching
Product creation on Conrad
Sending offers on Conrad
Removing products/offers from Conrad
Update offers on Conrad
Import orders from Conrad
Order update on Conrad
eCommerce
VirtueMart integration
VirtueMart node
Download orders from VirtueMart
Upload orders on Virtuemart
Upload products on VirtueMart
Download products from VirtueMart
Download product link from Virtuemart
WooCommerce integration
WooCommerce node
Download orders from WooCommerce
Download configurations from WooCommerce
Uploading orders on WooCommerce
Product publishing
Import products from Woocommerce
Plugin bindCommerce for WooCommerce
Prestashop integration
Prestashop node installation
Uploading orders on PrestaShop
Download orders from Prestashop
Downloading products from Prestashop
Product publishing on Prestashop
Connector for downloading Prestashop configurations
Magento integration
Magento node
Download orders from Magento
Upload orders on Magento
Product publishing on Magento
Import of Magento products
Shopify integration
Shopify node
Products import from Shopify
Publishing products on Shopify
Download configurations from Shopify
Integration of Mlveda's Multi Country Pricing App
Download orders from Shopify
Upload orders on Shopify
OpenCart integration
OpenCart node installation
Publishing products on OpenCart
Download orders from OpenCart
Import products from OpenCart
Uploading orders on OpenCart
Ecwid by Lightspeed integration
App installation and connection
Publishing products on Ecwid by Lightspeed
Import products from Ecwid
Import orders from Ecwid
Export orders from Ecwid
Social Networks
Facebook Catalogue integration
Configuring the Facebook Catalogue feed
Price comparators
Google Shopping integration
Translation and content enrichment
Integration with Google Translate
Integration with Icecat
Payment systems
Integration with PayPal
Import files
File format
Data file import
API for developers
API node
Export Orders
Import Products
Export Products
Documents import
Shipping update (legacy)

bindCommerce

bindCommerce s.r.l.

VAT Number IT07798861212 - SDI M5UXCR1
Registered in Napoli - REA: NA - 910618
Share capital € 20.000,00 fully paid
Tel: +39 011 089 122 0
E-mail: [email protected]

PON 2014>20 Riaccendiamo lo sviluppo