The 'Cross-sell' and 'Up-sell' are the proved marketing techniques for suggesting 'similar' and 'add-on' products/services respectively to encourage more purchases by promoting those products.

  • Note:
    • Cross-sell is a marketing technique of suggesting the 'similar products' or services to a customer when he/she is buying something.
      • For example, when an end-user is buying a cell phone, he/she may be shown a list of similar phones in the same or other brands that are available with you.

    • Up-sell is a marketing strategy of suggesting the 'add-on products or accessories' related to that product when the customer is buying it.
      • For example, if a customer is buying a cell phone, he may be shown a list of phone cases, USB Cables, memory cards, extra chargers, phone insurance products, etc…

    • The Cross-sell and Up-sell are used to encourage the purchase of higher-profit items and for increasing the average order size.

The ‘substitutes’ are the alternate products for the associated main products, and they are used while picking if the main products are not available in sufficient quantity.
  • Note: During an order fulfillment, it often turns out, that the order cannot be fulfilled because the item in the order is 'out of stock (OOS)'. In such cases, the picker can look for substitutes for the item in his picking app, and still fulfill the order. So, the picker will be able to check for a list of substitutes on his Picking App, select one of the substitutes and fulfill the order successfully.

The association of 'Cross-sell''Up-sell', or ‘Substitute’ products in a bulk quantity by category wise can be done here. Download the Excel sheet by category wise, update the respective cross-sell/up-sell/substitute products and upload the Excel here.

How do I associate SKUs for 'Cross-sell' or 'Up-sell' or 'Substitutes' in a bulk quantity?


To associate SKUs for 'cross-sell' or 'up-sell' or substitutes in a bulk quantity, do the following:

  • Log in to the 'Anywhere Commerce Control Panel' by using your User Name (Email Address) and Password.


 Bulk Attribute Values Upload

  • You will be navigated to the Dashboard page.


 Bulk Attribute Values Upload

  • Click the  Bulk Attribute Values Upload icon. The Products section will be displayed as shown in the figure.


 Bulk Associations

  • Click Bulk Tools, and select the Bulk Associations. You will be navigated to the Bulk Tools > Bulk Associations page.


 Bulk Associations

  • Select a category from the Select Category drop-down for downloading the SKUs of that category in an Excel format.
  • Select Cross Sell or Up Sell or Substitutes from the Type of Association drop-down under the Download Bulk Association Data Sheet section to bulk associate the Cross-sell or Up-sell or Substitutes respectively.
  • Click the Download Data Sheet. The respective Excel file will be downloaded as per the selected type of association as mentioned below:
    • Cross SellCrossSell.xlsx
    • Up SellUpSell.xlsx
    • SubstitutesBulkSkuAssociation.xlsx
  • To open the Excel, double click the Excel. Any of the above mentioned Excels will be displayed as shown in the figure.


 Bulk Associations

  • To associate the cross-sell or up-sell SKUs or substitutes (as per your the downloaded file), enter the relevant SKUs in the Associated SKU column.
  • Note: To associate multiple SKUs with a single product, repeat the base product's SKU in the SKU column and associate relevant SKUs in the Associated SKU column.
  • In the case of variant products, also enter the relevant variant SKUs in the Variant SKU column.
  • Enter the order of appearance of associated SKUs against each 'base product', in the Sequence No. column.
  • To delete the association, enter 'Y' or 'y' in the Delete Association column.
  • Save the excel in a suitable location as per your requirement.
  • To upload this excel, select Cross Sell or Up Sell or Substitutes (as per your downloaded file) from the Type of Association drop-down under the Upload Bulk Association Data Sheet section.


 Bulk Associations

  • Note: The maximum row limit for upload is 5000 and the file format should be .xlsx
  • Click Choose. You will be displayed a File Upload dialog box.


 Bulk Associations

  • Select the recently stored (Cross Sell.xlsx or Up Sell.xlsx or BulkSkuAssociation.xlsx) 'Excel sheet' and click Open.
  • The dialog box will be closed and the selected file name will be displayed in the Upload Excel text box.


 Bulk Associations

  • Click Upload. The upload status will be updated in the Bulk Association Upload Task History section.
    • Note: While the file is uploading, you can also find the Upload Status, Total Rows, Updated Rows, Failed Rows (due to Validations), Failed Rows (due to Exceptions), etc.. are being updated in runtime in the Bulk Association Upload Task History section.


 Bulk Associations

  • Note: You can download the latest associated data for cross-checking by clicking the relevant  Bulk SKU Association icon under the Actions column.
  • You can delete this task (if required) from the Bulk Association Upload Task History section by clicking the relevant  Bulk Associations icon under the Actions column.
  • In case of any failures of data association, you will be displayed a  Bulk Associations icon against that upload task in the Actions column of Bulk Association Upload Task History section.
  • Click the  Bulk Associations icon. You will be displayed a Opening BulkSkuAssosciationUpload_XXXXXXXXXXX.xls' dialog box.


 Bulk Associations

  • Select Save File and click OK. The dialog box will be closed and the file will be saved. To open the file double click it. The excel file will be displayed as shown in the figure.


 Bulk Associations

  • You can find the error in the Message column and other details in the respective columns. Rectify the error and again upload.
  • Repeat these steps for all categories for which the Bulk Cross-sell or Up-sell or substitutes association is required.