Details

Written by: Mariana Cherneva

Category: Tutorial Ecwid

Published: 21 November 2023

Hits: 753

Importing orders from Ecwid By Lightspeed to bindCommerce allows you to import all order-related information (buyer, shipping address, order lines) into bindCommerce, plus any custom parameters.

Orders imported into bindCommerce can in turn be exported to management software or another e-commerce site.

To import orders from Ecwid by Lightspeed the following configurations are required on bindCommerce:

• App installation and connection
• Order import configuration (to define which orders to import)
• Creation of connector to import orders from Ecwid by Lightspeed

The order import configuration is used to define which orders to import. In case of particular needs it is also possible to create multiple import configurations to be performed in different conditions.

To create the configuration, from your bindCommerce panel follow the menu “eCommerce (sales channel) > Ecwid by Lightspeed > Order import”, and then add a new configuration and fill in the fields as follows:

• Configuration name: enter an explanatory name for the configuration
• Filter by dates of: Select Created to import orders based on their creation date on Ecwid or select Edit to import orders based on their last modified date on Ecwid
• Make the request: select the date control criterion from:
  - For the last days: indicate the number of days to be considered and any delay (in number of days) compared to the connector execution date
  - For the last hours: indicate the number of hours to be considered and any delay (in number of hours) compared to the date of execution of the connector
  - Range date: to indicate the start date and end date non-dynamically
• Payment status: select which payment statuses to import (typically Paid is the most common selection) from:
  - Pending Payment
  - Paid
  - Cancelled
  - Your money back
  - Partially refunded
  - Incomplete
• Progress Status: select which order statuses to import from:
  - To be processed
  - In processing
  - Shipped
  - Delivered
  - Not delivered
  - Made
  - Ready for collection
  - Delivering

It is possible to select custom parameters (such as tax code or PEC) and select which field to import this information into bindCommerce.

Click Save and Close to finish configuration.

Finally, to create the import connector, you need to follow the “Processes > Connectors” menu, click on Add, and fill in the fields as follows:

• Connector name: for example “Ecwid Import Orders”
• Node Type (Technology): Ecwid eCommerce
• Node: Select the previously created node or create one by following the directions here
• Connector Type: Select Ecwid eCommerce [Orders Import]

Click Save and Continue to continue the configuration.

• Connector configuration: select the order import configuration previously created
• Product filter: optionally select a product filter

Click Save and Close to finish configuring the connector.

The connector thus configured can be executed (in jargon, launched) manually, from the list of connectors by clicking on the play button, or inserted into a procedure for automatic and scheduled execution.

Details

Written by: Mariana Cherneva

Category: Tutorial Ecwid

Published: 30 October 2022

Hits: 877

Importing products from Ecwid By Lightspeed to bindCommerce allows you to import all product information such as title, description, images, categories and price from Ecwid into bindCommerce.

All selected elements will be registered in bindCommerce to perform internal processing or for management through management software or for re-publishing on other supported platforms: eBay, Amazon, personal e-commerce site and many others.

To import the product catalog from Ecwid by Lightspeed the following configurations are required on bindCommerce:

• App installation and connection
• Product import API configuration (to define which information to import for each product)
• Product import configuration (to select the import API configuration, time parameters and any product filters)
• Creation of connector to launch product import from Ecwid by Lightspeed

The product import API configuration is used to define which information to import for each product.
On your bindCommerce panel, follow the “API > Import products” menu and add a configuration.

In the “Product import configuration” group:

• Configuration Name: Choose an explanatory name for the configuration
  Action type: select whether you want to create products in bindCommerce, update existing ones or both actions

In the “Information to consider” group it is possible to choose, with a simple selection, which product information to import:

• Product information: the Art. Code code is always imported (being the primary identifier of the product, which takes on the name of SKU in bindCommerce). The fields managed by the integration are the following: title, UPC (barcode), product name, description, brand or manufacturer, quantity, dimensions and weight, tags
• Prices: it is possible to import the price of the product and any discounted price from Ecwid. The prices will be imported into the Public price list and further price lists can also be generated from it
• Attributes: the imported attributes can then be used to enrich descriptions or titles and can be selected to create filters on products
• Categories: the categories with their related trees are imported

In the "Images" group you can select whether to transfer them to the WebServer (if it is not already present you will have to create it following the instructions here) or copy the URL of the images from Ecwid.

In the "Alternatives" group, in the case of multilingual product descriptions, it is possible to assign to each language to be imported the alternative description in which it must be transferred. In order to select an Alternative, it must have already been created, following the instructions here.
To add associations, click on the green + button.

In the "Deletion of untransmitted data" group it is possible to select the information that must be deleted in bindCommerce if it is not received during the import (for example because it was deleted by Ecwid).

In the “General Options” group you can select options as follows:

• Calculate parent product quantity from sum of variants?: If Yes, bindCommerce will sum the available stock for each product option and apply it to the parent product
• Calculate parent's price from the minimum of the variants?: if Yes, the minimum price found from the product options will be applied to the parent product
• Skip products marked as deleted: If Yes, products in deleted state in bindCommerce will not be imported

The product import configuration is used to define the products to import.
On your bindCommerce panel, follow the menu “eCommerce (source) > Ecwid by Lightspeed > Import products”, and then add a new configuration.

Give the new configuration a name. In the “Data to import” group, choose a previously created Product Import API Configuration, or create one on the spot by clicking +.

In the “Range” group, choose a previously created configuration or create one at the moment by clicking + and fill in the fields as follows:

• Configuration name: enter an explanatory name for the configuration
• Type: Select Products
• Filter by dates of: Select Created to import products based on their creation date on Ecwid or select Edit to import products based on their last modified date on Ecwid
• Make the request: select the date control criterion from:
  - For the last days: indicate the number of days to be considered and any delay (in number of days) compared to the connector execution date
  - For the last hours: indicate the number of hours to be considered and any delay (in number of hours) compared to the date of execution of the connector
  - Range date: to indicate the start date and end date non-dynamically

Click Save and Close to finish the configuration and select it from the drop-down menu.

In the “Filters” group, optional fields allow you to limit the number of imported products based on the following criteria:

• Categories: Select specific categories to import or leave blank to not exclude any
• Keyword: search for an exact term, the search is extended to every field of the product (name, sku, description, etc.) adding * at the end disables the exact search. Don't use special characters.
• SKU code: indicate a specific product code (by filling in this field all other filters and time parameters will be ignored)
• Inventory: Select Available to import products with quantities greater than zero or Out of Stock for products with zero quantities
• Price from/Price to: fill in to import only products in a certain price range
• Ecwid Options: Indicate specific Ecwid options to import. Syntax example: &option_Size=S,M,L&option_Color=Red,Black
• Ecwid Attributes: Indicate specific Ecwid variants that will be imported as attributes into bindCommerce. Syntax example: &attribute_Brand=Apple&attribute_Capacity=32GB,64GB
• Active: Yes/No to import products in active or canceled status
• Featured front page: if selected, imports only the featured products or not

Click Save and Close to finish configuration.

Finally, to create the import connector, you need to follow the “Processes > Connectors” menu, click on Add, and fill in the fields as follows:

• Connector name: for example “Import products from Ecwid by Lightspeed”
• Node Type (Technology): Ecwid eCommerce
• Node: Select the previously created node or create one by following the directions here
• Connector Type: Select Ecwid eCommerce [Product Import]

Click Save and Continue to continue the configuration.

• Connector configuration: select the previously created product import configuration
• Product filter: optionally select a filter on products already present in bindCommerce

Click Save and Close to finish configuring the connector.

The connector thus configured can be executed (in jargon, launched) manually, from the list of connectors by clicking on the play button, or inserted into a procedure for automatic and scheduled execution.

Details

Written by: Mariana Cherneva

Category: Tutorial Ecwid

Published: 30 October 2022

Hits: 1477

To publish the product catalog from bindCommerce to Ecwid by Lightspeed, the following configurations are required on bindCommerce:

• API export product configuration (to define which information to export for each product)
• Product export configuration (to define creation permissions and standard names for common attributes: barcode, manufacturer, and supplier)
• Product filter configuration (to define which products to export)
• Connector creation for product publication on Ecwid by Lightspeed

Product export API configuration

The product export API configuration is used to define which information to export for each product.
On your bindCommerce panel, follow the menu "API > Products export"
In the "Information to consider" group you can choose, according to your preferences, the following options:

• Export product information
• Export availability
• Export prices
• Export the attributes
• Export categories
• Exporting images

Product information

The SKU is always exported (being the primary identifier).
The fields managed by the integration are the following: barcode, product name, full description, manufacturer, supplier, weight, dimensions, metadata
It is possible to select only one alternative description for each language, which will populate the translations.

Stock availability

The additional warehouses will not be considered in the export to Ecwid.

Prices

It is possible to send Ecwid only one price list for each product (and the relative discounted price).
It is necessary to send at least the net price (excluding VAT) and the gross price (including VAT) which will then be displayed on the site based on the configurations chosen on Ecwid.

Attributes

Select the attribute values ​​to be sent in the main Ecwid language. Is it possible to perform any normalizations before sending to Ecwid using the option "Perform an attribute scale conversion?"

Categories

It is necessary to export the category key and the name. Optionally you can send the description and the big picture. By exporting the alternative descriptions it will be possible to populate the translation of the categories themselves.

Product images

It is necessary to send the images in large format

Product export configuration on Ecwid by Lightspeed

The product export configuration is used to define creation permissions and standard names for common attributes.
On your bindCommerce panel, follow the menu “eCommerce (sale channel) > Ecwid by Lightspeed > Product publishing”, and then add a new configuration.
In the “Data to export” group, choose a previously created API export product configuration, or create one at the moment.
In the "Options creation" group it is possible to choose:

• whether to create new categories when not present or link to products only to previously created categories,
• whether to create new products when not present, or update previously created products

Consider that after the creation of each element on Ecwid by Lightspeed (products, combinations of variants, categories) bindCommerce saves the correspondence between the Ecwid by Lightspeed identifier and the bindCommerce identifier in the list that can be consulted by following the “eCommerce (sales channel) > Ecwid by Lightspeed > References” menu. Thanks to these references, no duplicates are generated and it is possible to recall previously published elements. The table is left editable by the user to manage the solution of any anomalies and special cases.
In the group “Standard attributes names” it is possible to choose the names to be used by Ecwid by Lightspeed to identify these attributes (barcode, manufacturer / brand, supplier) in the main language.

Product filter configuration

To manage product filters, refer to the specific tutorial. 

Creating connector for publishing products on Ecwid by Lightspeed

Finally, to create the publishing connector, you need to follow the menu "Process > Connectors", click on add, and then:

• Give the connector a name (for example "Publish products on Ecwid by Lightspeed")
• Choose the type of node (technology) "eCommerce Ecwid by Lightspeed"
• Choose the node previously created
• Choose the type of connector "eCommerce Ecwid by Lightspeed [Product publishing]"
• Click on "Save and continue"

After the page has reloaded, you can:

• choose the previously created connector configuration
• optionally, choose the previously created product filter, or create one on the spot

The simulated mode will allow you to extract the products and write them in a log (without sending any data to Ecwid by Lightspeed).
The differential approach will eventually make it possible to reduce the number of products extracted, in the event that the update concerns only availability and prices.
Obviously, the created connector can be inserted in an automatic procedure.

Details

Written by: Mariana Cherneva

Category: Tutorial Ecwid

Published: 30 October 2022

Hits: 4562

The Ecwid by Lightspeed integration offered by bindCommerce from version 2.6.0, thanks to a special App, allows the dialogue with any Ecwid by Lightspeed site.
The integration project includes:

• Publishing and updating products on Ecwid by Lightspeed 
• Importing orders from Ecwid by Lightspeed 
• Updating order status on Ecwid by Lightspeed
• Importing products from Ecwid by Lightspeed 
• Exporting orders on Ecwid by Lightspeed