- Details
- Written by: Mariana Cherneva
- Category: Conversions and normalizations
- Hits: 1607
The Premium SKU recoding function allows you to use a different product code than the one in the bindCommerce product table, in the integration processes with external sales platforms (updating listings and downloading orders).
The function in question is very useful when the SKU codes present on bindCommerce do not correspond to the SKUs of listings already published on external platforms, where it is sometimes not possible to make changes to these codes, and where it would be counterproductive to close listings with a history of sales (and sometimes positive feedback).
Manual record creation
To configure the SKU re-code you need to access the menu:
Process >> Conversions and normalizations >> SKU recoding
where it is possible to view the table of correspondence of codes possibly already entered previously.
By clicking on Add it will be possible to create a new record:
- SKU in bindCommerce: indicate the SKU present on bindCommerce, making sure it does not contain spaces or characters different from the original
- External SKU: enter the SKU corresponding to the one present on the external sales platforms
- Reference node: select the reference node for coding the SKUs. If the SKU needs to be re-coded across multiple sales channels (eg eBay and Amazon), two records must be created, one for each channel.
- eBay: Market - select the reference market on which the SKU to be coded is in use.
- Marketplace Amazon: select the reference market on which the SKU to be coded is in use.
Click on SAVE AND CLOSE.
Creating records from import file
If there are many SKUs to be re-coded, it is possible to import from file.
To create the appropriate configuration go to the menu:
Import export files >> Import files >> Import SKU recoding
and click Add. Fill in the fields as follows:
- Configuration name: give the configuration the name you prefer
- File source: select the import method from those in the drop-down menu or click on the + button to add a new source. The fields to be filled in in this case will be:
- Type: HTTP/HTTPS, FTP/S-FTP or direct upload
- File URL: indicate the url from which the file can be accessed, without the protocol in front (for example dev.mywebsite.com/test.csv)
- HTTP authentication: Not required, Standard or Custom
- File type: select the type of file to import
- File extension: indicate the file extension
- Field names on the first line: select Yes if the field names are on the first line of the file or indicate them in the appropriate editor, divided by commas
- File encoding: select the expected encoding of the file to be imported
- Skip the first N lines of the file: indicate how many lines to skip (if necessary)
- Is the file compressed?
- Inbound controls: to be filled in only if you want to filter the records based on a specific parameter
- Text with separator: indicate the separator and the text qualifier (if any)
- SKU in bindCommerce: indicate the field name that shows in which column the SKUs present on bindCommerce are located in the file
- External SKU: indicate the field name that shows in which column of the file the alternate SKUs are located
- Reference node: select the reference node for coding the SKUs. If the SKU needs to be re-coded on both eBay and Amazon, it will be necessary to create two import configurations, one that considers the eBay node and the other that considers the Amazon node
- eBay: Market - select the reference market on which the SKU to be coded is in use.
- Market Amazon: select the reference market on which the SKU to be coded is in use.
Click on SAVE AND CLOSE.
The imported records will be visible in the table
Process >> Conversions and normalizations >> SKU recoding
Node and connector
To import the file it will be necessary to create the appropriate node and its connector.
First of all create a new node from the menu:
Process >> Nodes
Click on Add and fill in the fields as follows:
- Technology: select the file source value
- Name: give the node the name you prefer
Click on SAVE AND CLOSE.
Now go to the menu:
Process >> Connectors
Click Add to create a new connector. Fill in the fields as follows:
- Connector name: give the connector the name you prefer
- Node type (technology): select the file source value
- Node: the previously created node
- Connector type: select Import SKU recoding
Click on SAVE AND CONTINUE to access the additional fields to be configured:
- Connector configuration: select the configuration already created above
Click on SAVE AND CLOSE. The connector can be performed in manual mode or inserted within an automatic procedure.
Using SKU recoding
At this point, to activate SKU recoding on the various processes, it will be necessary to indicate Yes in the Perform SKU recoding field for each connector that requires it.
Normally, the recoding function is activated on connectors for publishing and updating products/listings and downloading orders.
- Details
- Written by: Mariana Cherneva
- Category: Conversions and normalizations
- Hits: 1496
The normalization of the order statuses allows you to make conversions between the various order statuses provided by the different sales platforms. In fact, the conversion makes it possible to ensure that there are no discrepancies in the process of downloading orders from one platform to another.
To create an order status conversion go to the menu:
Process >> Conversions and normalizations >> Order status normalization
Click on Add and fill in the fields as follows:
- Starting technology: select the type of platform from which the order status you want to convert comes from
- Starting order status: select the order status you want to convert
- Target technology: select the type of platform to which the order status will be converted
- Node: Select the node for the target technology
- Final order status: Select the final order status
- Final order line status - Select the status of the final order line
- Payment status: Three different options are available - Any - Paid - Unpaid
- Shipping status: Three different options available - Any - Shipped - Not Shipped
Click on SAVE AND CLOSE.
For each order status that you want to convert, you will need to create a new record in the table as explained above.
The conversion will be performed automatically by bindCommerce at each order download.
- Details
- Written by: Mariana Cherneva
- Category: Conversions and normalizations
- Hits: 1233
Currency conversion is a function that allows you to create correspondence with foreign currencies, and allows you to download orders in current currency.
This is a Premium option that can be used manually, creating matches directly on bindCommerce and updating them periodically, or using the Import conversion function of the currency conversion updated daily from an external site.
To create a new manual currency conversion go to the menu:
Process >> Conversions and normalizations >> Currency change
Click on Add and fill in the fields as follows:
- Entry date: optional field, select the creation date of the currency exchange
- From currency: select the source currency to convert
- To currency: select the currency into which the price is to be converted
- Multiplier: enter a value expressed in decimal numbers to determine the price conversion based on the starting currency
- Change of date: select the update date of the currency exchange
Click on SAVE AND CLOSE. Follow the same path for all conversions you want to make.
By taking advantage of the import file functionality, it will be possible to periodically update the exchange rates automatically. To configure the import file and its connector, please read the specific guide for Dynamic currency conversion.
Then it will be necessary to create an order transformation configuration in the following bindCommerce menu:
Process >> Conversions and normalizations >> Sales documents transformation
To create the configuration correctly, it is advisable to read the appropriate Order Transformation guide.
In case of currency conversion, select Yes in the "Run a currency conversion" field.
At this point, a section called "Currency conversions" will open, where you can select the target currency to be used for sending to the management system.
Click on SAVE AND CLOSE. At this point, move to the menu:
ERP >> Order export configuration
open the existing configuration (or create a new one if necessary) and select the configuration just created in the Order transformation field.
Click on SAVE AND CLOSE. Orders will now be exported with the correctly converted currency.
- Details
- Written by: Mariana Cherneva
- Category: Conversions and normalizations
- Hits: 1234
The scale conversion is a tool made available to create a correspondence between the values of the attributes present on bindCommerce and the standard ones required by eCommerce and Marketplace systems.
The use of scale conversion can be ideal in different situations, for example in the case of non-standard colors, or to replace customized size values with distinct standard sizes also based on the reference market (Europe, USA, UK). It is also possible to use the conversion to enrich the values of the attributes, perhaps if it is deemed necessary to use them when creating alternative descriptions or templates.
On bindCommerce there is a specific table with the different scales that can be used to carry out the various conversions. The scales are divided by type (General, Shoes, Translate, etc…) and several scales are available for each category.
To view the existing stairs just go to the menu:
Process >> Conversions and normalizations >> Standards
All’interno dell’apposita tabella si trovano tutte le scale disponibili, distinte dai seguenti campi:
- id: scale bindCommerce identification code
- Kind: macro category to which the scale belongs
- Scale name: the name of the scale
- Key: placeholder value to use when formulating a placeholder that involves value conversion. For example, for a conversion performed with the Condition of the product scale, when formulating the placeholder to recall that conversion, the value to use will be "condition_type"
To create a new scale conversion it will be necessary to go to the menu:
Process >> Conversions and normalizations >> Conversions
Click Add to create a new conversion. The fields present are:
- Tye of scale: select a scale macrotype based on the value you want to convert (for example Shoes)
- Manufactirer: select the manufacturer for which you want to convert. If the conversion must be generic, and therefore on all producers, leave the field blank
- Starting scale: the scale to convert
- Starting value: the value to convert. Make sure that the value entered is identical to the one present on bindCommerce
- Target scale: in the case of Spartoo it will always be necessary to choose one of the scales with the prefix eu_, for example European shoe scale
- Target value: the value of the European scale
At the end click on the SAVE AND CLOSE button.
The converted value at this point can be recalled within configurations, alternative descriptions or templates through the use of a simple placeholder like this one:
{[(attribute|id==ID dell’attributo presente su bindCommerce|kind==categoria_della_scala|rescale_from==scala_di_partenza|rescale_to==scala_di_destinazione|value)]}
EXAMPLE: we created a scale conversion using the Shoes category, the starting scale is European shoe scale and the target scale is US Men. The placeholder for calling conversions with these characteristics will be: {[(attribute|id==1|kind==shoes|rescale_from==eu_shoes_general|rescale_to==us_man|value)]}