Details

Written by: Mattia Rigotti

Category: Prestashop

Published: 18 September 2015

Hits: 1192

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

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

Correspondence creation for order status normalization

Uploading orders to a Prestashop shop requires that correspondences be created between the external order statuses and those registered on your site.

In order to create these matches, it is necessary to follow the instructions given in the specific Order Status Normalization tutorial.

 

Configuration for uploading orders on Prestashop

The first thing to do will be to create a special configuration for the connector that will take care of loading the orders. Then go to the menu:

eCommerce >> Prestashop >> Order upload

A page will open containing all the possible options to fill in

Common options

In this section, we can specify an 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.

Prestashop

In this tab it is necessary to enter a series of specific data for Prestashop and necessary for order loading to be successful:

• Node Prestashop: choose the Prestashop node previously created
• Language selection: allows you to choose in which languages, installed on the Prestashop store, to import orders. This information is downloaded from the Prestashop configuration download connector.
• Payment method to be applied to all downloaded orders: allows you to specify the same payment method for all downloaded orders or, leaving the field blank, this information is taken from the orders themselves.
• Server where to upload the order file: specify the server address.
• Folder on the server to save the order file: the folder must correspond to the one in which the site was installed.
• FTP user: username used for connection.
• Password FTP: password used for connection.
• bindCommerce script address: enter the address of the bindCommerceLoadOrders.php file loaded on the server.

Order uploading connector

We remind you that before creating the connector it is necessary to install the Prestashop 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: scegliere un nome per identificare il connettore
• Node type (technology): select eCommerce Prestashop
• Node: choose the previously created node
• Connector Type: Choose the type of connector: eCommerce Prestashop [Uploading orders on PrestaShop]

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: from the drop-down menu indicate the order uploading configuration created previously
• Order filter: if necessary, specify the previously created order filter. For more information on this, consult this section of the guide: Setting filters on orders.
  
  

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

Details

Written by: Daniele Sborgia

Category: Prestashop

Published: 10 December 2014

Hits: 1816

The goal of this connector is to publish the products on bindCommerce within the stores created with Prestashop. 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 "automatically run" from a scheduled procedure.

Product publishing options on PrestaShop

Before creating the connector, you need to set up the product publishing configuration. Then go to the menu:

eCommerce >> Prestashop >> Product publishing

e selezionare il tasto Aggiungi.

First you can choose between two options:

• Creation of products in PrestaShop store
• Modification of existing products in the eShop

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 primary identification key.

The category identification key used to manage updates is built by appending the names of the categories in the main language, which will form a field called "keycat", so if a category is renamed or moved in the categories 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, in fact it never deletes the categories on the eShop, which may have been created with other methods independent of bindCommerce).

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
  
• 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 porduct image
  
• insert category image
  
• insert metadata and tags
• enter featured products
• unpublish products  (if availability is updated)
• use the heaviest weight between the real and volumetric one

Options for modifying existing products in the eShop

The upgrade options are listed below:

• 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 sort: select the attribute that contains the numerical value that will determine the ordering of the products on the site. The attribute will be considered only if correctly filled in
• Where to get the available quantity for the products? - This option allows you to choose whether to withdraw the stock from the product table or to use the Quantity rules function. This is a premium option, for configuration see the specific guide.

You can choose to include some attributes in the publication. The attributes selected here will be published on the online shop.

Note for products from Danea Easyfatt: This option is particularly useful to exclude from the publication the Color attribute that Danea creates whenever it is defined that a product is of type "Item with stock (Size/Color)" even if in fact it affects only one of the 2 parameters (eg size). In these cases, the publication of both parameters on PrestaShop would create a "false" product sheet, giving the user the possibility to choose size and color from 2 different drop-down menus, in which the color attribute would always be fixed at the default value ( -).

For a correct connector configuration, it is advisable to carefully consider the characteristics of the connectors involved in the specific configuration area.

In the same section it is also necessary to specify the target language on the site.

Scale conversion and manufacturer/brand name normalization

Scale conversion is a tool made available to create a matching between the specific values of an attribute saved in bindCommerce and any different reference values.

To create optimal scale conversions, please consult the appropriate technical tutorial.

Price lists and prices

bindCommerce can manage multiple price lists and among the options of the connector that publishes the products on PrestaShop 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 PrestaShop 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 which has as possible options:

• Price excluding VAT on bindCommerce
• Price including VAT on bindCommerce / (1+VAT): to solve the problems of rounding to the nearest hundredths. 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 PrestaShop 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 decsriptions to the main one

The option allows you to publish the values of products present in an alternative date, rather than the main ones, on WooCommerce. We will use this possibility to manage the publication in alternative languages or with a different format. To generate alternative descriptions, please refer to the appropriate technical tutorial.

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.

Prestashop

This section collects a series of specific options for Prestashop:

• Node: the previously created reference node
• Publishing language: the language used for publishing on Prestashop
• Shop: The store where the products are to be published
• Enter a minimum purchase quantity for products? - this option allows you to consider as a minimum quantity a value other than 1. In some cases, for reasons of warehouse management, it may be convenient to indicate a higher number.
• Associate the quantity with a group, instead of the shop? - activate only in case of multishop management

Click on SAVE AND CLOSE.

Creating the connector

We remind you that before creating the connector it is necessary to install the Prestashop 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 the connector
• Node type (technology): choose Prestashop eCommerce
• Node: choose the previously created node
• Connector Type: Choose the Prestashop Connector Type [Product Publishing].

Click on SAVE AND CONTINUE to access the following fields:

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 you can choose whether and which filter to apply. To create a product filter, please consult the specific guide.

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.

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

 

Details

Written by: Daniele Sborgia

Category: Prestashop

Published: 10 December 2014

Hits: 1289

The goal of these connectors is to download the orders that customers have placed on eCommerce stores made with Prestashop on bindCommerce.

At the same time as the orders are downloaded, the stock availability on bindCommerce can be updated, and as a result (thanks to other connectors) the quantities available for sale on the various online stores and on marketplaces such as eBay can be updated.

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

Options for downloading orders from PrestaShop

The first thing to do will be to create a special configuration for the connector that will take care of downloading the orders. Then go to the menu:

eCommerce >> Prestashop >> Order download

Click on Add and fill in the fields as follows:

• Configuration name: indicate the name you prefer
• eCommerce platform: select eCommerce Prestashop

Click on SAVE AND CONTINUE to access the specific fields of the configuration.

Select period

It is possible to choose whether to download all the orders each time, or only those of a given more recent period. If you try to download an existing order, it will be updated and not duplicated, but if there are a large number of orders, it is not sensible to re-execute the complete download every time (greater volume of data to transfer and process), but, in according to your discharge policy, limit the range only to a given period.

It is, therefore, possible to choose to download orders from a date on, or not older than a certain period

Common options

When you are downloading an order from a customer already present on bindCommerce (recognized by the relative email address), you can choose to update the relative personal data (name, address, etc.), or not. Normally the best choice is to perform the update (to always have updated data available).

What to do if there is no shipping address

On Prestashop you can specify the billing address and, without making it explicit, say that the shipping address is the same. When downloading orders on bindCommerce, to have a more complete situation (without empty fields), you can choose to populate the shipping address using the billing address. If there are no particular reasons to the contrary, we recommend setting this option.

Filter by order status

You can choose to download all orders on bindCommerce (do not filter by status), or download only those orders that are in a particular status.

Update stock availability on bindCommerce

This option allows you to choose which order statuses to update stock availability, decreasing the quantities purchased.

Order status to be considered as "Canceled"

Here you can specify which order status, among those managed and linked to PrestaShop, to be considered as Canceled on bindCommerce.

Create products not present on bindCommerce

If the products contained in the downloaded orders are not present (SKU not present) you can choose to have bindCommerce create the downloaded product, or not. If the product is not created, it will not be possible to monitor its stock availability.

Order line uniqueness key

This option allows you to specify if the unique key must be the SKU or if the SKU must be entered together with the description.

Prestashop

Within this tab it is necessary to enter the Prestashop node previously created and the information about the store. The latter is downloaded from the Prestashop configuration download connector.

PayPal - Translactions

This is a premium option that allows you to report information relating to payment via PayPal within orders. In this section, it will be necessary to indicate the PayPal node previously created.

For more information about this feature, consult the PayPal tutorial

Electronic invoice

In this section it is necessary to enter the name of the two fields intended for electronic invoicing in PrestaShop. They can usually be found in orders or from any module that manages the functionality.

Creating the connector

We remind you that before creating the connector it is necessary to install the Prestashop 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 the connector
• Node type (technology): choose the Prestashop eCommerce node
• Node: choose the previously created node
• Connector type: choose the Prestashop eCommerce connector type [Download orders on bindCommerce].

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.

• Connector configuration: in this field, it is necessary to enter the previously created configuration for unloading orders.

Once the changes are complete, click on SAVE AND CLOSE.

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

Details

Written by: Daniele Sborgia

Category: Prestashop

Published: 10 December 2014

Hits: 1420

The handling of products in relation to Prestashop nodes is bidirectional. It is not only possible to publish products with the appropriate connector, but also to "pick up" the products present on one site and then possibly 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 "automatically launched" from a scheduled procedure.

 

Product import configuration

Before creating the connector, you need to set up the product import configuration. Then go to the menu:

E-Commerce >> Prestashop >> Product import

click on the Add button and fill in the fields as follows:

• Configuration name: enter the desired name
• eCommerce platform: select Prestashop eCommerce
• Web Server for image storage: select the web server for the images among those available in the drop-down menu. To create the web server node, refer to the appropriate guide
• What kind of imports to perform ?: choose the value that best suits your needs between Products and Links to products
• From which language of the site to pick up: select the language of the site from which the products will be imported

Then continue with the specific fields to define the fields that will be considered in the import phase:

• Create products in bindCommerce? - by selecting YES you will have access to a series of items that can be checked to determine which data will be considered for the creation of the products
• Modify existing products on bindCommerce? - by selecting YES you will have access to a series of items that can be checked to determine which data will be considered for the modification of the products

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

NOTE: Consider that in order to decide whether it is necessary to carry out 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, dimensions and custom
• options
• enter categories
• enter child products
• enter product - category combination
• enter manufacturer
• insert images
• enter prices
• enter stock availability
• insert category image
• enter metadata
• insert featured products

Options for editing existing products in bindCommerce

The options for editing existing products are as follows:

• update product name, description, notes, dimensions 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

Finally, there is another premium option that is valid both in creation and in 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.

Prestashop

In this section there are some fundamental parameters to indicate for the correct functioning of the communication with the eCommerce platform.

• Node: choose the Prestashop node previously created
• Language to import from: allows you to choose in which languages, installed on the Prestashop store, to import the products. This information is downloaded from the Prestashop configuration download connector.
• Shop (id): Allows you to choose the id linked to the Prestashop shop from which to import the products. This information is downloaded from the Prestashop configuration download connector
• Single store url: this field must be filled in ONLY if you have a multi-store management
• Download only matches for existing data? - Selecting Yes enables the download of matches only for data already existing on bindCommerce.
• Delete all existing references before importing new ones? - In general it is good to use this option only in case of real need, for example if elements are manually deleted on Prestashop and not on bindCommerce, as the latter would try to update elements using reference ids that no longer exist, generating a mistake.
• Number of products to extract for each request: the default is 0 in order to import products with a single request, but if this should create problems, which usually occur when there is a lot of data to import, you can enter values ​​other than 0 (eg: 100) in order to limit the load on the Prestashop server
• Record form which to start from: allows you to start importing from a specific record
• Maximum number of products to import: in this field you can choose a specific number of products to import by setting a maximum

Alternative choice

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

Finally click on SAVE AND CLOSE.

Creation of the Prestashop product download connector

We remind you that before creating the connector it is necessary to install the Prestashop 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 Prestashop eCommerce
• Node: choose the previously created node
• Connector type: choose eCommerce Prestashop [Download products on bindCommerce].

Configuration

The previously created import configuration from PrestaShop must be indicated in this field.

Product filter

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

Once the changes are complete, save the configuration.

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