Details

Written by: Daniele Sborgia

Category: Tutorial Internal processing

Published: 08 April 2019

Hits: 1283

This feature allows you to generate derived products starting from those already present on bindCommerce. For example, it is possible to generate derived products for sale in batches, rather than for modular items. This is an option that is part of the Premium features.

The creation takes place directly on the bindCommerce platform and does not require you to make any changes to your original product archive.

Derives list

To generate the derivative products, it is first necessary to fill in the appropriate table of the derivatives list. From the menu:

Catalog >> Derived products >> Derived products list

access to the specific section.

Click Add on the top left to create a new derived product. The fields to be filled in are the following:

• Main product SKU: the SKU of the main product for which you want to create the derived product, and therefore already existing on bindCommerce
• Derived product SKU: the SKU to be associated with the derived product to be created on bindCommerce
• Barcode type: select the type of barcode to be assigned to the derived product
• Barcode: enter the barcode to be associated with the derived product. If you do not have the barcode, you can replicate the sku entered in the derived SKU field
• Quantity per pack: enter the number of pieces that make up the derived product
• Price multiplier: enter the value by which the price of the main product must be multiplied to generate the price associated with the derived product

Click on SAVE AND CLOSE.

For each derived item that you intend to generate it will be necessary to create a new entry in the derived products list.

If you want to create an assembled derived product, i.e. composed of two or more SKUs already existing in the product catalog, you will need to create as many derived SKUs as there are main SKUs. For example, if you have a table to be assembled, consisting of top and legs, which in the catalog are two items with distinct SKU, but you want to create a derived product that includes the sale of the entire table, you will proceed as follows:

First derived product

• Main product SKU: the SKU of the first main product, for example, TABLE_TOP
• Derived product SKU: the sku to be associated with the derived product to be created on bindCommerce, for example, TABLE

Second derived product

• Main product SKU: the SKU of the first main product, for example, TABLE_LEGS
• Derived product SKU: the SKU to be associated with the derived product to be created on bindCommerce, for example, TABLE

In this specific case the SKU of the first derivative product and of the second must be identical, so in our case, both in the first and in the second case the SKU will be TABLE.

For each main product included within the derived product, it is, therefore, necessary to generate a derived SKU.

Within the Creation and modification tab, after the first start of the connector, it will be possible to observe details about the creation of the derived product, such as the ids of the creation and modification connectors and the relative IDs of the execution logs.

Derivative rules

Before being able to proceed with the creation of derived products, it is required to fill in a specific configuration available in the menu:

Catalog >> derived products >> derivative rules

Click Add on the top left to create a new derived product. The fields to be filled in are the following:

• Rule name: choose the configuration name
• Type of action: select from the drop-down menu the type of action to be carried out in relation to derived products. The values available for this section are: Product Creation, Product Update, Product Creation and Update, Update ONLY Quantity and Price
• Which attributes to consider: in this section, it is possible to choose whether to consider all the attributes associated with the main product or select only some of them that will be inherited from the derived product
• Price list from which to take prices: select the price list from which you want to take the price to be associated with the derived product

Once the configuration is complete, click on SAVE AND CLOSE.

Connector for the generation of derived products

Remember that before creating the connector it is necessary to install the bindCommerce node with which the connector will operate. Then you need to go to the menu:

Process >> Connectors

and click on the Add button.

The following parameters must therefore be chosen:

• Name connector: choose a name to identify what the connector does
• Node type (technology): choose bindCommerce. After choosing the type of node, the Node and Connector Type fields will be updated, presenting the choices compatible with that type of node
• Node: choose the previously created node
• Connector Type: Choose the type of Data Processing [Derived Products] connector.

Click on SAVE AND CONTINUE to fill in the further sections of the connector.

• Configuration: in this field, it is necessary to insert the derivation rule previously created.
• Product filter: in this section of the connector it is possible to choose if and which filter to apply among those previously created through the menu Processes -> Product filter

The connector can be run in interactive mode (by clicking on the button Run the connector immediately?) Or through automatic procedures.

The generated derived products will be visible from the menu

Catalog >> Products

Details

Written by: Valentina Cascio

Category: Tutorial Internal processing

Published: 07 February 2019

Hits: 1532

With this feature it will be possible to download orders with foreign currency on your management system, automatically converting the original value with the exchange rate of the target currency. This is an option that is part of the Premium features.

By taking advantage of the import file functionality, it will also be possible to periodically update exchange rates.

The first thing to do is to create a new file import configuration, through the menu

Import export files >> Import files >> Import file settings

Click the Add button at the top left.

A new import file configuration will be created. First of all, you will need to fill in the following fields:

• Name: enter a name of your choice for the configuration
• What kind of imports to perform: select Currency exchange - www.floatrates.com

By clicking on the SAVE AND CONTINUE button you will have access to the further configuration fields.

Enable the option "Filter the records to be imported based on a field in the file itself? (Input check)".

Assuming we want to convert the currency from dollars (USD) to euros (EUR), we value the fields as follows:

• Field to compare: enter the fixed value "code"
• Comparison operator: select "=" 
• Value to compare: insert "EUR" ( Indicate the ISO code of the target currency, always consisting of 3 characters, such as EUR for the Euro currency, USD for the dollar, etc.)

In the section called File location, under "Withdrawal type" select the "http (web address)" option.

As the file address use the following URL:

www.floatrates.com/daily/ followed by the ISO code of the source currency (written in lower case) + the extension .json.
 

In our example, the URL to be entered will be the following: www.floatrates.com/daily/usd.json

Click on SAVE AND CLOSE. At this point, it will be possible to create an import file connector to associate it with.

It is advisable to insert the connector created in a procedure so that it is performed once a day to have the conversion multipliers always updated.

Conversions can be viewed in the table found in the menu:

Process >> Conversions and normalization >> Currency change

At this point it will be necessary to create an order transformation configuration at the following bindCommerce menu:

Process >> Conversions and normalization >> Sales documents transformation

To create the configuration correctly, it is advisable to read the special Sales Document Transformation tutorial.

In the case of currency conversion, select Yes in the "Perform a currency conversion" field.

At this point, a section called "Currency conversions" will open, where you can select the target currency that must 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: Daniele Sborgia

Category: Tutorial Internal processing

Published: 24 December 2018

Hits: 1197

Order transformation is a premium option of bindCommerce that allows you to vary specific information related to the same when exporting to other platforms. Let's see in detail the steps to configure the functionality.

Configuring order transformation

It is possible to create all the necessary transformation configurations from the following bindCommerce menu: 

Process >> Conversions and normalizations >> Sales documents transformation

By selecting the Add button, multiple records can be created.

After giving a name to the configuration, you can proceed with the tab that contains the transformation options.

Activating each feature will load the various options:

Transform billing address

Activating it, the "Billing address" tab will appear at the bottom where you can configure multiple fields that will be replaced in the order during the export.

Transform shipping address

Activating it, the "Shipping address" tab will appear at the bottom where you can configure multiple fields that will be replaced in the order during the export..

Transform sales prices

By activating it, the "prices" tab will appear at the bottom from which you can choose the price list to be used to recalculate the sales prices. The currency set on the specific price list will be applied.

Transform other information on the document

Activating it, the "Other Information" tab will appear and from this section, it is possible to apply further options such as a prefix to be added to the order number

Transform payment data

By activating it, the "Payment details" tab will appear which will allow you to choose a specific method or keep the original and possibly modify the collection costs.

Transform shipping data

By activating it, the "Shipping data" tab will appear which will allow you to choose a specific method or keep the original and possibly change the shipping costs.

Perform a currency conversion

Activating it, the "Currency Conversions" tab will appear from which you can choose the target currency to apply. The exchange rates will be taken from the "VAT rate groups" table available in the "Processes -> Processing configuration -> VAT rate groups" menu, which can be populated manually or automatically via the currency exchange function

Reset the VAT

By activating it, the "VAT recalculation" tab will appear where you can indicate the VAT value to be used among those present in the drop-down menu or you can enter a different value using the "Add" button.

Export expenses and discounts as an order line

By activating the function in question, you can enter an SKU and a description for each value relating to Shipping costs, collection costs, shopping cart discount, coupon discount. This way the expenses in question will be exported as order lines.

Conversion of derived into main products

This option transforms the derived products into main products according to the pre-filled table on bindCommerce relating to the derived products.

Transform document number

This option allows you to transform the document identifier (the id field of the "Sales documents" section), starting from the number indicated in the Document number starting value field, or starting from 1 if a specific number is not indicated.

If this function is activated, the identification number of the document sent to the management system will be the one provided by the numbering inserted in the fields. The document correspondence register will be available from the menu

Process >> Conversions and normalizations >> Sales documents transformation >> Corrispondence documents

The table shows the type of document, the destination node, the number of the converted document, and the number of the original document present on bindCommerce, finally the date of issue of the correspondence.

Details

Written by: Daniele Sborgia

Category: Tutorial Internal processing

Published: 14 December 2018

Hits: 1129

The barcode type calculation script is used to carry out an analysis of the structure of the barcodes present on the products and on the basis of this calculate the type (EAN, ISBN).

This type of function can be very useful when you want to publish products that have a barcode whose type is not indicated in the appropriate field, on marketplaces such as eBay and Amazon, which require the type of barcode used.

The operations to be carried out are essentially two:

• Creating the configuration
• Creating the connector

Internal processing settings

The page from which it is possible to create the barcode type calculation configuration is found in the menu

Process >> Processing configuration >> Internal processing

By selecting Add you can create a new record.

The first fields to be filled in will be:

• Name: choose a name
• Script: select Barcode type determination

Once the two parameters have been entered, select SAVE AND CONTINUE to load the remaining sections.

The following options are optional, and it is recommended to activate them only for specific cases. On all other occasions, it is possible not to activate them.

• Do you want to recalculate the code already valued? - This option is used to perform a new calculation also on the barcodes whose type is already present. It should only be used in case of actual variations
• Select priority checks on the code: in this section, you can specify whether to provide control priority over some types of code over others
• Delete unrecognized barcodes?? - Activating this option, all the barcodes whose type is not recognized by the script will be removed from the products

Connector execution

To create the connector that will perform the determination of the type of barcode, follow the menu:

Process >> Connectors

clicking on Add a new connector will be created, at this point, it will be necessary to choose a name and fill in the following data as follows:

• Node type: bindCommerce
• Node: Select the previously created bindCommerce node
• Connector Type: Data Processing [Custom Configuration]

Click on SAVE AND CONTINUE to access the further configurations:

• Product filter: select if necessary
• Configuration: select the configuration created previously

then click on SAVE AND CLOSE. The connector can be run immediately manually or within a procedure.

Remember that it is always possible to apply a filter to the processes so that the changes are applied only to the desired items. For the creation of a product filter, please refer to the appropriate tutorial.