Details

Written by: Mattia Rigotti

Category: Shopify integration

Published: 21 August 2019

Hits: 1186

The installation of Shopify type nodes allows you to allow bindCommerce integration platform to communicate with online stores built in the Shopify environment.

The installation consists in inserting an authorization key and a password that will allow the dialogue of the e-commerce platform with bindCommerce, but let's see the configuration of the node from the beginning.

API key and password

The first operation to perform to make communication between your Shopify website and bindCommerce possible is to recover the API key and password.

To get them, just go to your administrative area (mywebsite.myshopify.com/admin where mywebsite is the name of the store, while the rest of the address is static) by entering your credentials.

At this point, on the left, click on the App item to access the list of installed apps. At the bottom of the page, you will then find the Manage private apps button.

At the top right of the new page, click on Create a new private app and give it a name, once saved, the required data will appear: API key and Password.

 

Node

Go to the menu:

Process-->Nodes

and click on the Add button.

• Techonlogy: indicate with which application the bindCommerce must communicate. In this case Shopify eCommerce.
• Name: choose the name to give to the node.

Once finished, click on the Save and Continue button to bring up more specific sections.

Website address

• Protocol: communication protocol of the website where Shopify is installed;
• Url: the web address of the shop must be the one used to access the administrative area (mywebsite.myshopify.com where mywebsite is the name of the store, while the rest of the address is static) without protocol (http / https).

Shopify

In this section, we will finally be able to enter the API key and password recovered previously. It will also be necessary to indicate the name of the shop, available in the backend of the site, from this menu: Settings -> General.

Sales channel costs

These are useful parameters for calculating commercial profitability. It is possible to specify a fixed cost per sale and an average percentage cost.

Finally, click on SAVE AND CLOSE. Now, bindCommerce is ready to communicate with the Shopify store.

 

Details

Written by: Mattia Rigotti

Category: Shopify integration

Published: 23 December 2015

Hits: 1352

The goal of this connector is to publish the products on bindCommerce within the stores built with Shopify. The publication may be complete with all data and images, or it may be an update of only some restricted data, such as stock availability.

The execution of the connectors can be activated in interactive mode, by clicking on the appropriate button, or be started automatically by a scheduled procedure.

 

Shopify product publishing options

To create a specific configuration to be applied to the connector that will publish the products on Shopify, go to the menu:

eCommerce >> Shopify >> Product publishing

select the Add button and fill in the fields as follows:

• Configuration name: enter the desired name
• eCommerce platform: select Shopify eCommerce

First you can choose whether the connector should perform:

• Creating products in the eShop (Shopify store)
• Modification of existing products in the eShop

Consider that the SKU code is used as the primary identification key to decide whether a new product entry or update is required.
The identification key of the categories used to manage the updates is built by appending the names of the categories in the main language, which will form a field called "keycat", therefore, if a category is renamed or moved in the category tree, it will be identified as a new category (the update will not be done, but a new category will be created in addition to the previous one. The categories on the eShop are never deleted as they may have been created with other methods independent of bindCommerce, for example manually).
For each of these actions, the following options are available.

Options for creating new products in the eShop

• enter product name, description, notes, size and custom options
• enter categories: categories will not be created in WooCommerce, but select anyway to make the product-category combination
• insert child products
• enter product - category matching
• enter manufacturer
• enter prices: keep in mind the options described below in relation to the price lists to be considered
• enter stock availability
• insert product image
• insert category image
• enter metadata and tags
• enter featured products
• unpublish products out of stock (if availability is updated)
• use the heaviest weight between the real and volumetric one

Opzioni per la modifica dei prodotti esistenti nell'eShop

• update product name, description, notes, attributes, sizes and custom options
• update child products
  
• delete product - category pairing
• enter product - category matching
• update maufacturer
  
• update category name and description: it will not work with the name in the main language because if its name changes, the keycat, identification key of the category itself, will change and will therefore be interpreted as an addition
• update prices: keep in mind the options described below in relation to the price lists to be considered
• unpublishes the products reported as canceled on the integrator
• update stock availability
• update product image
• update metadata and tags
• updates featured products
• unpublish products out of stock (if availability is updated)
• use the heaviest weight between the real and volumetric one
• unpublish categories left without published products (acts on the whole store)

General options

• Attribute from which to take the order: the attribute must contain a numeric value and is useful for specifying a real order for each product that will be reflected within the site, positioning the articles in the frontend exactly as you wish;
• Where to get the quantity available for the products? - This is a premium option that allows you to define advanced rules to send inventory quantities different from the real ones, for example by limiting the maximum, sending a fixed value, taking data from an attribute or calculating the stock as a percentage of the real one;
• Which attributes to consider: You can choose to include certain attributes in your publication. Activating the option will load the Attributes selection tab. Those selected will be published on the online store.
• Target language on the site: specify in which language the articles are published;
• Attribute scale conversion: scale conversion is a tool made available to create a correspondence between the specific values of an attribute saved in bindCommerce and any different reference values. To create scale conversions, please consult the appropriate tutorial.

Further down, in the Attribute scale conversion tab, you can determine the attribute to convert, the starting scale and the target scale.

• Manufacturer/brand normalization: in a similar way to the conversion of attributes, it is possible to convert producers, using the same logic.

Category options

This option allows you to use a tag to decide which categories to send. This is not a product filter. The same will be sent regardless, but matched only to categories with the specific tag.

Price lists and prices

bindCommerce can manage multiple price lists and among the options of the connector that publishes products on Shopify there is the choice of which price lists to publish. In this regard, it is necessary to pay close attention to the key used by Shopify to identify the price list (see in this regard the price lists management).

In this section it is necessary to choose which country code to use for the VAT rate.

Finally, let's consider the "Copy the price" field has as possible options:

• Price excluding VAT on bindCommerce
• Price including VAT on bindCommerce / (1 + VAT): to solve the problems of rounding to the cent. This option is used to manage the problems of rounding the price to 2 decimals.

The problem derives from the fact that the price including VAT is not saved on the Shopify price table, but the VAT excluded price (which on the database can reach up to 5 decimals), and then it is multiplied by 1.22 (1 + VAT) to obtain the price including VAT, and if we keep to 2 decimals, sometimes there is no VAT excluded price that makes a round figure.

Let's take the example of a product with a price of € 180.00 including VAT, the price excluding VAT is € 147.54 (147.54 x 1.22 = 179.9988 rounded to € 179.99). If it had been € 147.55, the calculated price including VAT would have become 180.011 which is rounded up to € 180.01. When prices are fed by Danea, both VAT excluded and VAT included (rounded correctly) are present. If we choose the second option, bindCommerce will use the VAT inclusive price and obtain the VAT excluded price to 5 decimal places, which are sufficient to obtain a correct rounded calculation.

Choice of alternative descriptions to the main one

The option allows you to publish the values of products present in an alternative date, instead of the main ones, on Shopify. We will use this possibility to manage the publication in alternative languages or with a different format.

If there are no values for the selected alternative, the system will use those of the main tables.

Tags

In this tab we have the possibility to activate the sending of tags, specifying the picking field. We have several options: from the Tags field of the product table, from a free field, from the Notes field or from an attribute.

Shopify

This section collects a number of Shopify-specific options:

• Use plug-ins for multi-pricing? (mlveda): specify if you use the mlveda plugin to manage multipricing. By activating the option, the Shopify Multi pricing tab will automatically be loaded in which you can select the price lists to be included in the sending; consult the specific guide for integration with the mlveda plugin.
• Been published for new products? - Thanks to this option, new articles can go online for the first time directly as published or temporarily disabled on any sales channel.
• What price to publish? - Specify whether gross or net prices will be considered.

Connector creation

We remind you that before creating the connector you need to install the Shopify node on which the connector will operate. After doing this, go to the menu:

Process --> Connectors

and click on the Add button.

The following parameters must therefore be chosen:

• Connector Name: Choose a name to identify what the connector does
• Node Type (Technology): Choose Shopify eCommerce. After choosing the node type, the Node and Connector Type fields will be updated, showing the choices compatible with that node type
• Node: choose the previously created node
• Connector Type: Choose the type of Shopify eCommerce [Product Publishing] connector.

Then click on SAVE AND CONTINUE to access the further configurations of the connector.

Configuration

In this field it is necessary to enter the configuration for the product publication previously created

Product filter

In this section of the connector it is possible to choose whether and which filter to apply among those previously created through the menu Process -> Product filter

Differential approach

The differential approach is used to optimize the repeated execution of the connector under the same configuration conditions (options and filter applied). By checking the last successful execution of the process, it extracts only the articles that have undergone a real modification and not every time the entire archive.

Esecuzione del connettore

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

Details

Written by: Mattia Rigotti

Category: Shopify integration

Published: 23 December 2015

Hits: 1408

The movement of products in relation to Shopify nodes is two-way. It is not only possible to fill the site with the appropriate connector, but also to take the products present on one website and then eventually publish them on another.

The product download may be complete with all data and images, or it may be an update of only some restricted data, such as stock availability.

 

The execution of the connectors can be activated in interactive mode, by clicking on the appropriate button or be started automatically by a scheduled procedure.

Product import configuration

The product import configuration can be reached from the menu:

eCommerce >> Shopify >> Product import

To create a new configuration, select the Add button and fill in the fields as follows:

• Configuration name: enter the desired name
• eCommerce platform: select eCommerce Shopify
• Web Server for image storage: select a web server from those available. To create a web server node, please consult the appropriate tutorial.
• What kind of imports to perform? - select Products to import all the information relating to the products, or Link to the products to transfer only the URLs of the products useful for the publication of advertisements to bindCommerce, for example on Kijiji
• From which language of the site to download: select the language from which you want to import the products

First, you will be able to choose whether the process should perform:

• Creation of products in bindCommerce
• Modification of existing products in bindCommerce

For each of these actions, the following options are available.

Consider that to decide whether it is necessary to make a new insertion or an update of the products, the SKU code is used as the primary identification key.

The identification key of the categories used to manage the updates is built by appending the names of the categories in the main language, which will form a field called "keycat", therefore, if a category is renamed or moved in the category tree, it will be identified as a new category (it will not be updated, but a new category will be created in addition to the previous one).

Options for creating new products in bindCommerce

The options relating to the creation of products not present are the following:

• enter product name, description, notes, size, and custom options
• enter categories
• enter child products
• enter product - category matching
• enter manufacturer
• insert images
• enter prices
• enter stock availability
• insert category image
• enter metadata
• enter featured products

Options for editing existing products in bindCommerce

The options for editing existing products are as follows:

• update product name, description, notes, size, and custom options
• update child products
• delete product - category combination
• add product - category combination
• update manufacturer
• update prices
• update stock availability
• update product image
• update category image
• update category description
• update metadata
• update featured products
• set the quantity to 0 for products not present in the file
• mark as canceled and set the quantity to 0 for products not present in the file
• delete images produced NOT transmitted?

Finally, there is an additional premium option that is valid both in a creation and in a modification of the articles:

• Convert the relative URLs present in the description into absolute: it can be useful when you want to download products that have images inserted in the body of the description and saved on the database in the form of relative URLs, which would not be visible outside the site.

Alternative choice

Once you have chosen the options to perform, you can decide whether to save the data in an alternative instead of in the product list. It is useful for managing, for example, alternative languages to the main one.

Shopify

In this section there are more specific parameters to indicate:

• Maximum number of products to import: in this field, it is possible to choose a specific number of products to import by setting a maximum;
• VAT rate to be applied to the prices of imported products: Set a VAT rate value for the products to be imported.

Creation of the Shopify product download connector

We remind you that before creating the connector you need to install the Shopify node on which the connector will operate. After doing this, go to the menu:

Process --> Connectors

and click on the Add button.

The following parameters must therefore be chosen:

• Connector Name: Choose a name to identify what the connector does
• Node Type (Technology): Choose Shopify eCommerce. After choosing the node type, the Node and Connector Type fields will be updated, showing the choices compatible with that node type
• Node: choose the previously created node
• Connector type: choose eCommerce Shopify [Download products on bindCommerce].

 

Configuration

In this field, the previously created configuration of importing products from Shopify will be indicated.

Product filter

In this section of the connector, it is possible to choose whether, and which filter to apply, among those previously created through the function setting filters on products.

Once the changes are complete, save the configuration.

Connector execution

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

Details

Written by: Mattia Rigotti

Category: Shopify integration

Published: 23 December 2015

Hits: 1094

The goal of these connectors is to upload orders that pass through bindCommerce to Shopify, both for updating purposes, for example to update the status of orders on Shopify and add information such as tracking number, shipping date and courier, both to upload orders from other platforms to the same.

The execution of the connectors can take place automatically (scheduled procedure), or manually.

Matching creation for order status normalization

Uploading orders to a Shopify shop requires that you create correspondences between the external order statuses and those registered on your site.
In order to create these correspondences, please consult the appropriate guide.

Setup for uploading orders to Shopify

The first thing to do will be to create a special configuration for the connector that will take care of loading the orders. It can be configured by going to the menu:

eCommerce >> Shopify >> Order upload

Clicking on Add will open a page containing all the possible options to be entered.

Common options

In this section we can specify a possible option for Order Transformation and specify whether the update will be minimal or complete. The minimal update will only send information related to status and tracking number.

Attributes

This tab allows you to indicate, if necessary, the attributes that determine the color and size.

Shopify

In this last tab it is possible to specify whether to automatically update the quantity of the product when uploading the order and whether to carry out a complete uploading or possibly only an update of the status linked to the order.

Order uploading connector

We remind you that before creating the connector you need to install Shopify node on which the connector will operate. After doing this you need to go to the menu

Process --> Connectors

and click on the Add button.

The following parameters must therefore be chosen:

• Connector name: choose a name to identify what the connector does, for example: Update orders on eMotikO Shop
• Node type (technology): by choosing the Shopify eCommerce 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 Connector Type: Shopify eCommerce [Uploading Orders to Shopify]

After having set all the parameters, click on the SAVE AND CONTINUE button. The page will reload and you will be able to parameterize the connector options.

• Configuration: use the drop-down menu to indicate the previously created order loading configuration
  Order filter: if necessary, specify the previously created order filter. For more information on this, consult Setting filters on orders.

Activation

As already happens for other connectors, the execution can take place manually (by clicking on Run the connector immediately?), Or automatically by means of a scheduled procedure.