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.

thumb prestashop product publishing

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

 

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
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
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
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
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