Details

Written by: Valentina Cascio

Category: Tutorial platform bindCommerce

Published: 04 March 2019

Hits: 1327

The premium Multi Warehouse function allows you to manage the stock of items, as well as on a main warehouse, on alternative warehouses.

Alternative warehouses can be related to a supplier, to its own secondary warehouse, or to a competitor.

List of alternative warehouses

The list of alternative warehouses can be compiled from the menu

Catalog >> Multi warehouse >> Warehouses

By creating a new warehouse, clicking on Add at the top left, you will need to fill in the following fields:

• Name: assign the name you want
• Key: fill in the field only if the data is imported via API
• Warehouse type: select the desired value from those available (supplier warehouse, own warehouse, competitor warehouse)

At the end click on SAVE AND CLOSE.

Import of the stock data on the different warehouses

To import the data relating to the stock on the various warehouses, you can use the import file function, internal to bindCommerce, or import via API.

The import file function allows you to import the stock to the different warehouses through the use of a file. The file specifically must contain a column for the item sku, and a column for each warehouse that you want to import with the corresponding stock value for each product.

To perform the import via file, just create a special configuration, following the instructions available in this tutorial, and fill in the fields in the section called Multi-warehouse stock:

• BindCommerce warehouse: select one of the previously created warehouses, for example TEST warehouse.
• Warehouse on file: report the column header corresponding to the selected warehouse. For example, if the TEST warehouse corresponds to the stock_supplier2 column in the file, you will have to enter “stock_supplier2” in this field.

By starting the appropriate import file connector, the stocks for each warehouse will be imported on bindCommerce.

For import via API you can request the complete tutorial to the use of the bindCommerce API.  Contact us.

When the data relating to the stock have been imported for each warehouse, it is possible to view them from the menu

Catalog >> Multi warehouse >> Availability

The table contains information relating to sku, alternative warehouse name, stock, date of the last update.

Use of alternative warehouses

The stock shown in each alternative warehouse can be used to diversify the stocks destined for the various sales platforms thanks to the Quantity rules function.

The Quantity Rules function allows you to choose an alternative to the product table from which to take the quantity for each item. To choose an alternative warehouse it will be necessary to fill in the fields as follows:

• Where to take the quantities from?: select the item From an alternative warehouse
• Warehouse: select the alternative warehouse you want to use

or

• Where to take the quantities from?: select Calculation
• Formula: enter the calculation formula you want to use to determine the stock destined for one or more sales platforms. The fields that can be recalled in the formula are the attribute IDs, the stock of the main table and the ID of the alternative warehouses.

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

The previously created quantity rule can then be recalled within different configurations for the publication and updating of articles, both to eCommerce and to marketplaces. It can also be used during the import file and export file phase.

Details

Written by: Daniele Sborgia

Category: Tutorial platform bindCommerce

Published: 21 December 2018

Hits: 1238

The bindCommerce connectors used to download and upload orders allow you to choose whether to apply a filter to control which sales documents to manage, and which to exclude. The list of filters can be reached from the menu

Process >> Order Filter

To create a new filter just click on Add at the top left, choose the name to be given to the filter and the type of documents to be filtered, then click on SAVE AND CONTINUE to access the subsequent configurations.

The operator to be considered among the various filters is an AND (only the products for which all the inserted filters are verified are published).

If you want to use the OR, you can create multiple connectors with different filters applied (each one will run independently, so it is as if there were an OR operator among them).

Now let's analyze in detail the various types of filters that can be used.

Origin of the order

• Filter by order origin node?
• Node comparison rule
• Order origin nodes
• Business orders

From this section it is possible to select or exclude the nodes, i.e. the platforms integrated by bindCommerce, through which the orders have been created.

When the filter is used on order update connectors, it is not necessary to specify the node of origin, as it is applied by default.

Range temporale

Questo filtro permette di scegliere il periodo da considerare per lo scarico/carico. Sono impostabili valori in date, giorni, ore, o si possono selezionare tutti, ma non è consigliabile sia per quanto riguarda il carico a cui si sottopone il processo, sia se il connettore in questione è in una procedura automatica.

Se ad esempio la procedura si eseguisse una volta al giorno non avrebbe senso scaricare/caricare ogni volta tutti gli ordini possibili.

Time range

In this section there are multiple filters that allow you to consider the orders to download / upload based on multiple specifications:

• Consider only manually pre-selected orders? - Orders are selectable from the bindCommerce order list
• Export orders only once: this option allows you to export only orders that have not already been managed, keeping a record of the exports made
• Do you want to filter on the "Customer notes" field of the order? - It is possible to filter the orders according to the content of the notes, inserting only a part of the string in the field
• Filter by order status? - By activating this option, only the order states of your interest can be selected
• Filter by shipping status? - Field based on the valid evaluation of the shipping date. Allows you to consider only orders shipped / not shipped

Payment method

It is possible to manage the downloading / uploading of orders even based on the payment method present on them. Activating the option will load the comparison rule and the choice options

Amounts

It contains preloaded options to manage orders based on the amounts present within them, for example the control over the value of the total amount.

Products destination

In this tab you can manage the order based on the shipping country. By activating the option, the comparison rule and all shipping countries will appear.

Details

Written by: Paolo Tateo

Category: Tutorial platform bindCommerce

Published: 17 July 2013

Hits: 1323

Most bindCommerce connectors provide the ability to apply a filter on products, to ensure that only certain items are considered by the process.

The list of filters can be reached from the menu

Process >> Product filters

The operator to be considered among the various filters is an AND (only the products for which all the inserted filters are verified are considered).

If you want to use the OR, you can create multiple connectors with different filters applied (each one will run independently, so it is as if there were an OR operator among them).

To create a new filter just click on Add at the top left, choose the name to be given to the filter and click on SAVE AND CONTINUE to access the subsequent configurations.

Now let's analyze in detail the various types of filters that can be used.

SKU code, title, without variants

• Filter on SKU?
• Sku comparison rule
• SKU
• Filter on product name?
• Only products that DO NOT have any variations
• Only products that have variations

The options on this tab allow you to filter only products whose product code (SKU) contains or does not contain a given portion of text.

To filter a list of SKUs, on the other hand, you can use the linked "SKU Selection" table, accessible from the general list of filters, in the last column of the table. Just add the codes to be filtered within the appropriate section and indicate one of the two available options within the filter: "Same as SKU value list", "Different from SKU value list".

The option related to the title allows instead to filter only the products whose name contains or does not contain a given portion of text.

There is also the possibility of using the "%" character as a wildcard, both for the SKU field and for the Title field.

For example, if you want to filter all items that have SKU code with a specific prefix, it will be inserted in the appropriate "Prefix%" field.

Derived

• Consider derived products?

This filter allows you to choose whether to also consider derivative products (default option), whether to exclude them completely or whether to consider only the latter. For more details on derivative products, please refer to the specific tutorial.

Categories

• Filter the categories?

This option allows you to filter only the products associated with one or more selected categories. The comparison rule gives the possibility to make the comparison also by exclusion ("Different from").

Mnaufacturer and supplier

• Filter on manufacturer?
• Filter on supplier?

This option allows you to filter only the products of one or more manufacturers and/or one or more suppliers. Again you can work by exclusion ("Different from").

Stock availability

• Filter on stock availability?
• Alternative warehouses
• Filter only the products reported as deleted?

This option allows you to filter the products based on their stock availability, using all the comparison operators (greater, greater or equal, lesser, equal, etc ...).

The Alternative Warehouses option, on the other hand, allows you to filter the stock by considering one or more specific warehouses (if any). If no value is indicated, the main warehouse will be considered by default, i.e. the stock indicated in the product list. For the use of the multi-warehouse function, refer to the appropriate one guida.

The card also contains an additional filter: the one that only allows you to extract the items marked as deleted in bindCommerce. Useful for example when you need to close listings on marketplaces or disable items within an eCommerce.

Language and origin

• Perform a filter on the language?
• Eseguire un filtro sul nodo di provenienza?

In this tab there are two options: the filter on the language allows you to filter only the products whose language is indicated in the connector, while the filter on the node of origin extracts all those created by a specific platform integrated with bindCommerce.

Manual marking

• Filter on manual markings?

This option allows you to filter only the products manually marked in the product sheet (simple mark or list of tags).

Saleability

• Filter products that have not be sold on sales channels
• Filter products that have not be sold on sales channels

This filter allows you to extract the salable or non-salable products on specific sales channels.

Refers to the data entered in the distribution grid section.

Attributes

• Attribute to filter
• Attribute filter operator
• Attribute Value

This option allows you to filter only products that have an attribute valued as specified in the connector.

Several operators are available to perform the comparison, including the LIKE with the possibility of exploiting the "%" character as a wildcard in the attribute value.

To perform a filter on multiple attributes just click on the green button on the right and add a new row.

Note: it is not possible to perform a filter on the same attribute but with two different values (for example Season = Spring + Season = Summer). The filter must be run on different attributes.

Prices

• Filter on price?

This option allows you to filter only products that have price characteristics as specified in the connector. You can filter each price list in bindCommerce by net, gross and discounted price, and you have multiple operators: equal, greater and equal, lesser, lesser and equal, etc.

Dimensions and weight

• Filter on product weight?
• Filter on product length?
• Filter on product width?
• Filter on product height?

This option allows you to apply a filter on the weight, length, base and/or height of the product, in a range between a minimum and a maximum value.

Creatio and update date

• Perform a filter on the creation / update date?

This filter allows you to extract products based on their creation or update date, for example in cases where you want to publish new articles.

Remember that after activating the option, you need to save the filter to see the field appear where you can set the number of days.

Limit on the number of products

• Limit the number of products

Useful filter as it allows you to extract a specific number of products (parent or main) from a given record.

For example, it is used in cases where you want to avoid sending too large files to an eCommerce platform (in case of limitations on server resources).

For example, to divide 3000 products into 3 different sections, you will have to create 3 filters with three different values:

1. Search record to start from = 0, Number of products to extract = 1000
2. Search record to start from = 1001, Number of products to extract = 1000
3. Search record to start from = 2001, Number of products to extract = 1000

Sorting is given by the product id.

Images

• Only products with at least one image

By activating the option it is possible to insert a control on the product photos making sure to extract only those that have at least one. This avoids going to publish articles without images.

It is recommended to always use this option for publications to marketplaces when there are articles without photos, to prevent the error from being reported with the relative blocking of article publication. In fact, for publication on marketplaces, generally the presence of at least one photo is mandatory.

Barcode

• Filter on barcode?

This check, if activated, can perform multiple checks, such as checking if the barcode field is simply populated or if it is populated and what type of barcode it is (EAN or ISBN)

Details

Written by: Paolo Tateo

Category: Tutorial platform bindCommerce

Published: 16 April 2013

Hits: 1215

bindCommerce has a special section to consult, modify or delete customer master data.

For each sale made and downloaded on bindCommerce, a customer record is created in the table, accessible from the menu

Sales >> Customers

At a first glance, the table presents the basic information available for each customer:

• ID
• Name
• Surname
• E-mail
• Personal Tax Code
• City
• State / Province / Region

Each record can be edited or deleted. It is also possible to create new records manually, by clicking on the Add button at the top left.

From the table you can also access orders relating to each customer, from the last column of the table called Orders. By clicking on the value of the relevant cell you will have the list of orders, if any, connected to that particular customer.

Note: the e-mail address is the unique value that bindCommerce uses to avoid creating duplicate records. Each record is created and compared with those already present based on the email address.

Customer card detail

For each customer it is possible to view and/or modify the details in the specific tabs on bindCommerce.

By entering edit mode within the customer card you will have access to the personal data:

• Origin node
• Company
• Title
• Name
• Middle name
• Surname
• User ebay

contact references, such as e-mail or telephone, and tax information.

The detailed sheet also contains the data relating to the address, and any specific commercial information:

• Customer code
• Default price list
• Default payment method
• Default shipping method