The Premium SKU recoding function allows you to use a different product code than the one in the bindCommerce product table, in the integration processes with external sales platforms (updating listings and downloading orders).

The function in question is very useful when the SKU codes present on bindCommerce do not correspond to the SKUs of listings already published on external platforms, where it is sometimes not possible to make changes to these codes, and where it would be counterproductive to close listings with a history of sales (and sometimes positive feedback).

 

Manual record creation

To configure the SKU re-code you need to access the menu:

Process >> Conversions and normalizations >> SKU recoding

where it is possible to view the table of correspondence of codes possibly already entered previously.

 

thumb sku recoding 1

By clicking on Add it will be possible to create a new record:

  • SKU in bindCommerce: indicate the SKU present on bindCommerce, making sure it does not contain spaces or characters different from the original
  • External SKU: enter the SKU corresponding to the one present on the external sales platforms
  • Reference node: select the reference node for coding the SKUs. If the SKU needs to be re-coded across multiple sales channels (eg eBay and Amazon), two records must be created, one for each channel.
  • eBay: Market - select the reference market on which the SKU to be coded is in use.
  • Marketplace Amazon: select the reference market on which the SKU to be coded is in use.

Click on SAVE AND CLOSE.

Creating records from import file

If there are many SKUs to be re-coded, it is possible to import from file.

 

thumb sku recoding 2

To create the appropriate configuration go to the menu:

Import export files >> Import files >> Import SKU recoding

and click Add. Fill in the fields as follows:

  • Configuration name: give the configuration the name you prefer
  • File source: select the import method from those in the drop-down menu or click on the + button to add a new source. The fields to be filled in in this case will be:
    • Type: HTTP/HTTPS, FTP/S-FTP or direct upload
    • File URL: indicate the url from which the file can be accessed, without the protocol in front (for example dev.mywebsite.com/test.csv)
    • HTTP authentication: Not required, Standard or Custom
    • File type: select the type of file to import
    • File extension: indicate the file extension
    • Field names on the first line: select Yes if the field names are on the first line of the file or indicate them in the appropriate editor, divided by commas
    • File encoding: select the expected encoding of the file to be imported
    • Skip the first N lines of the file: indicate how many lines to skip (if necessary)
    • Is the file compressed?
    • Inbound controls: to be filled in only if you want to filter the records based on a specific parameter
    • Text with separator: indicate the separator and the text qualifier (if any)
  • SKU in bindCommerce: indicate the field name that shows in which column the SKUs present on bindCommerce are located in the file
  • External SKU: indicate the field name that shows in which column of the file the alternate SKUs are located
  • Reference node: select the reference node for coding the SKUs. If the SKU needs to be re-coded on both eBay and Amazon, it will be necessary to create two import configurations, one that considers the eBay node and the other that considers the Amazon node
  • eBay: Market - select the reference market on which the SKU to be coded is in use.
  • Market Amazon: select the reference market on which the SKU to be coded is in use.

Click on SAVE AND CLOSE.

The imported records will be visible in the table

 

Process >> Conversions and normalizations >> SKU recoding

Node and connector

To import the file it will be necessary to create the appropriate node and its connector.
First of all create a new node from the menu:

Process >> Nodes

Click on Add and fill in the fields as follows:

  • Technology: select the file source value
  • Name: give the node the name you prefer

Click on SAVE AND CLOSE.
Now go to the menu:

Process >> Connectors

Click Add to create a new connector. Fill in the fields as follows:

  • Connector name: give the connector the name you prefer
  • Node type (technology): select the file source value
  • Node: the previously created node
  • Connector type: select Import SKU recoding

Click on SAVE AND CONTINUE to access the additional fields to be configured:

  • Connector configuration: select the configuration already created above

Click on SAVE AND CLOSE. The connector can be performed in manual mode or inserted within an automatic procedure.

Using SKU recoding

At this point, to activate SKU recoding on the various processes, it will be necessary to indicate Yes in the Perform SKU recoding field for each connector that requires it.

Normally, the recoding function is activated on connectors for publishing and updating products/listings and downloading orders.

 

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