1. How do I download my product data of my store in a bulk quantity?
How do I download my product data in an Excel format?
What are Add-on products? How can I add them?
How can I add normal product and deal products?
- To download required product data in a bulk quantity, do the following:
- Log in to the 'Anywhere Commerce Control Panel' by using your User Name (Email Address) and Password.
- You will be navigated to the Dashboard page.
- Click the
icon. The Products section will be displayed as shown in the figure.
- Click Bulk Tools, and select Bulk Product Download. You will be navigated to the Bulk Tools > Bulk Product Download page. By default, the Store Category tab will be opened.
- To download the required product data, click Choose. You will be displayed a Select Category dialog box.
- The categories that are configured with your store will be displayed here. Select the required categories/sub-categories.
- Click Submit. The Select Category dialog box will be closed and the name of the selected Category (categories) will be displayed in the Category text box.
- Click Generate File. The respective data will be downloaded and the download status will be updated in run-time under the Import Tasks section.
- You can delete this task (if required) from the Import Tasks section by clicking the relevant
icon. - To get the downloaded product data, click the
icon of that respective download task under the Action column of the Import Tasks section. The ProductCatalogXXXXXXXXXXXXXX.xlsx file will be downloaded. - To view and modify the product data, double-click on the ProductCatalogXXXXXXXXXXXXXX.xlsx file and the Excel will be displayed as shown in the figure.
- Note: There are two sheets here: 'Sheet1' and 'Definitions'. The Sheet1 contains product data, and the Definitions sheet contains the definitions/description of each column in 'Sheet1'.
- Update the data as per the given fields and store the file in a suitable location.
- Note: First go through the Definitions sheet for knowing exactly what each column of the Sheet1 denotes.
- For your quick reference, the definitions are also mentioned here:
| Name of the filed | Definition |
|---|---|
| Category Reference* | It is the unique reference code of each Category. You can add only existing Category reference codes of your store here. Download the list of your existing Category reference codes through the 'Products > Bulk Tools > Default Data' |
| SKU* | Enter Stock Keeping Unit (SKU), which is a unique identifier for each of the distinct products with a limit of 50 characters here. (%, &, ” ,', < not allowed) |
| Variant SKU* | Enter the SKU of 'Product Variant', which is a unique identifier for each of the distinct 'Product Variants' with a limit of 50 characters here. (%, &, ” ,', < not allowed) |
| Brand ID* | Enter the unique identification number of Brand here. Download the list of existing brands through the 'Products > Bulk Tools > Default Data' |
| Product Title* | Enter the name/title of the product with a limit of 100 characters here. |
| Inventory | Enter the stock (quantity) of the product here. |
| MRP | Enter the Maximum Retail Price of the product here. |
| Web price | Enter the selling price of the product at your web store here. It should be less than MRP. |
| Availability | Enter True if the product is Active and available in Storefront, else enter False. Deactivated products can't be visible at Storefront. |
| Small Image 100*100 | Enter the details of the small image here, which will be displayed in the Product Showcase (if the Custom Type of image is not defined and if Extended Properties section of that Product Showcase has not configured accordingly.) |
| Large Image 300*300 | Enter the details of the basic large image here, which will be displayed on 'Product Details' page. |
| Short Description | It's the brief description of the product within 500 characters, which will be shown beside the product image in the Product Details page. |
| Product Description | It's the detailed description of the product within 50000 characters, which will be shown through 'Description' tab in the Product Details page. |
| Payment Option-Online | Enter Y to apply the Credit Card/Debit Card/Net Banking Checkout for this Product, else enter N. End-users can pay the order amount through Credit Card or Debit Card or Net Banking facility. |
| Payment Option-Cheque/DD | Enter Y to apply the Cheque/DD Checkout for this Product, else enter N. The end-users need to create 'Cheque/DD' (as per details mentioned by you) for Order Amount and send it to you after placing the Order. |
| Payment Option-Bank Transfer | Enter Y to apply the Online Bank Transfer Checkout for this Product, else enter N. The end-users need to transfer the order amount to the account details as mentioned by you after placing the Order. |
| Payment Option-COD | Enter Y to apply the Cash on Delivery Checkout for this Product, else enter N. The end-user pays the order amount to courier person after receiving the Product. |
| Delivery Option-Ship | Enter Y if you provide Shipping for his product, else enter N. |
| Delivery Option-Offline | Enter Y to display the 'Call for Actions' for this product on the Product Details page, else enter N. Note: 'Call for Actions' are lead generating mechanisms, which act as the interfaces between you and end-users. |
| Delivery Option-Online | Enter Y to allow online deliveries such as Donations, Mobile recharges, etc… where there is no delivery after payment, else enter N. |
| Delivery Option-InStore Pickup | Enter Y if you provide pickup at store facility for this product else enter N. |
| Location Based Inventory | Enter Y if product's saleable inventory should be taken from the selected location/store rather than aggregating across the locations/stores, else enter N. That means if you enter Y, the inventory against the user selected location only will be considered while placing orders instead of considering the cumulative inventory against all locations. |
| Shipping Code | A 'Shipping Code' facilitates to apply required Shipping charges to a product. Enter the applicable Shipping Code(s) here. |
| Tax Code | A 'Tax Code' facilitates to apply Tax charges to a product. Enter the applicable Tax Code(s) here. |
| Delivery Time | Enter the approximate delivery time in either text or digits or alphanumeric form. For example, Within 48 Hrs, 7 Days, etc… Whatever you enter here, it will display the same in Storefront. |
| Catalog Sequence | Enter the sequence of Catalog (if any) here. This sequence will be useful to display the products in the order of 'Catalog Sequence' if 'Catalog Sequence' is selected from 'Dynamic Sequence' drop-down in the Extended Properties section of Product Showcase. |
| Shipping Weight | The existing 'Product Weight' is renamed as 'Shipping Weight'. When the Product or Variant is not sold on the weight basis, and the weight is required only for defining shipping charges, 'Shipping Weight' is used. Shipping weight is considered for the Product or Variant when the 'UOM' is in 'Pieces'. It is the unit weight which cannot be changed in Picklist by Picker. |
| Variant Property 1 | Enter the 1st 'Variant Property' of the product (if any) for classification of the product. Example: Color |
| Val1 | Enter the value of 1st 'Variant Property' (if any) here. Example: Orange |
| Variant Property 2 | Enter the 2nd 'Variant Property' of the product (if any) for classification of the product. Example: Size |
| Val2 | Enter the value of 2nd 'Variant Property' (if any) here. Example: 85 |
| Variant Property 3 | Enter the 3rd 'Variant Property' of the product (if any) for classification of the product. Example: Design. |
| Val3 | Enter the value of 3rd 'Variant Property' (if any) here. Example: Checks. |
| Variant Property 4 | Enter the 4th 'Variant Property' of the product (if any) for classification of the product. Example: Sleeve |
| Val4 | Enter the value of 4th 'Variant Property' here. |
| Variant Property 5 | A variant (or Variant Property) is a specific feature/property used for classification of that product. Enter the value of 5th 'Variant Property' here. |
| Val5 | Enter the value of 5th 'Variant Property' (if any) here. Example: 'V' Shape |
| Product Tag | Tags are the ‘Keywords’ that can be associated with products for classification & filtration. Enter the 'Global Tag(s)' for the required products in the 'Pipe separated' format. Note: 1. If you left the 'Product Tag' column blank, the existing 'global tag' association with the respective products will be removed. 2. However, if you delete the 'Product Tag' column and upload the Excel, the previous 'global tag' association against the respective products will be retained. 3. If you specify some global tags in 'Product Tag' column, the existing 'global tag' association against the respective products will be removed and the latest global tags will be associated with the respective products Refer: Product Tags |
| Offer Product Description | Enter the description of the offer (if any offer is there on this product) here, which will be displayed in the Products Details page just below the product image i.e. in Offers tab. |
| Offer Product Image 300*300 | Enter the image details of the offer (if any offer is there on this product) here, which will be displayed in the Products Details page just below the product image i.e. in Offers tab. |
| Page Title | Enter the title of the page in the way you want to display it in the search results when searched through Google for SEO (Search Engine Optimization) purpose. |
| Keywords | Enter the 'Meta tag keywords' for your product's page for SEO purpose. |
| Keyword Description | Enter the 'Meta tag description' about your product's page for SEO purpose. |
| SEO URL | Enter the 'keywords for your product's page URL' for SEO purpose. The same keywords will be inserted in that product's page URL and helpful in SEO. |
| Small Image Alt Text | Enter the 'alternate text of small image' for SEO purpose to search that image through this tag words |
| Large Image Alt Text | Enter the 'alternate text of large image' for SEO purpose to search that image through this tag words |
| Start Date | Enter the Start Date for the validity of Product or Variant in the storefront in the DD/MM/YYYY format. |
| End Date | Enter the End Date for the validity of the Product or Variant in the storefront in the DD/MM/YYYY format. The product will not be displayed in storefront after expiry period unless you have opted the 'Show Expired' as Y'. |
| StartTime(HH:MM:SS) | Enter the Start Time (In the HH:MM:SS format) |
| EndTime(HH:MM:SS) | Enter the End Time (In the HH:MM:SS format) |
| Periodicity Type (Onetime/Weekly/Monthly) | Periodicity type allows you to define the time period (‘Onetime, Weekly, and Monthly’) that denotes the validity of the product at your Web store. You have the option to show/hide the product after this validity. |
| Periodicity Range Weekly(1-3/1,3,5), Monthly(1-3/1,3,5) | Define the time frame as per the opted periodicity type. Example: Weekly: 1-3 or 1,2,3(Note: 1= Monday) Monthly: 10-13 or 10,11,12,13, (Note: 10=10th day of month). Note: Don't enter anything for Onetime |
| ShowExpired(Y/N) | To display the products in storefront after the expiry of validity, enter Y, else enter N |
| UOM | Enter the 'Unit of Measurement' as Pieces or Gms or Kgs or Litres. If UOM is Kgs, Gms or Litres, the 'Buying Weight' has to be defined. |
| LBH | It's the Volumetric Weight. Enter the product's Length, Breadth, and Height here. LBH will be the total of LxBxH. If Product has Variants, the LBH need to be defined at Variant Level. |
| BuyingWeight | Buying Weight will be the base weight of the Product or Variant and will override the 'Shipping Weight'. It can be modified by the user in Picklist App and modified weight will be considered for the price calculation and final invoice. |
| Pkg Qty | Package Quantity is the lot size (or batch size) of a specific product that is acceptable to you. The order can be placed only for the multiples of ‘Pkg Qty’ provided the order qty satisfies the 'Minimum Order Quantity' criteria. |
| Minimum Order Quantity | Enter the minimum purchase quantity of the product for each order. |
| Maximum Order Quantity | Enter the maximum purchase quantity of the product for each order. |
| Pre Order | Preorders allow the end-users to reserve a new product before the official launch of that product. Enter True or False to specify preorder facility is available for this product or not. |
| Back Order | Backorders allow the end-users to place orders even when the stock is expired. Enter True or False to specify backorder facility is available for this product or not. |
| Stock Available Message | You can display a suitable message about stock availability in case of Preorder and Backorder, in the Product Details page. Enter suitable message about stock availability in the Stock Available Message text box. |
| Product Condition | Enter New or Used as per the condition of the product |
| Warranty bearer | Enter the Warranty provider as Manufacturer or Dealer or No Warranty as per the source of warranty |
| Warranty In Months | Enter the warranty for this product in months(If Warranty bearer is Manufacturer or Dealer) |
| Reserve Quantity | To reserve a product for some special purpose, enter the reserve quantity here. For example, you can reserve some products for regular customers, loyalty customers, to create an artificial shortfall, etc… |
| Reorder stock level | Enter the quantity at which you want to reorder the product. |
| Stock Alert Qty | Enter the stock alert quantity at which you want to get a stock alert. This quantity helps in alerting you when the stock of the product reaches to this level so that you can do the needful action. |
| Bar Code | A barcode is an optical machine-readable representation of data, which shows data about the object to which it attaches. Enter the Bar Code of this product (if any) here. In the case of multiple barcodes for this product, enter them comma separated. |
| Model Number | Enter the 'model number' of the product (if any) here. |
| Catalog Code | Enter the 'Catalog Code' of the product (if any) here. |
| Purchase Date | Enter the date of purchase of the product in the DD/MM/YYYY format here. |
| Product Note | Enter the additional information about the product (if any) here. This is for internal reference only and not displayed on any page. |
| Form Code | Ad-hoc Forms allow you to create customized web forms with a number of custom fields and you can use them to receive customized orders from end-users. To display a suitable Ad-hoc form in the Product Details page, enter the relevant code. |
| Checkout With Token Price | Enter Y or N to specify whether to allow checkout with the Token price (partial/full advance amount) or not. |
| Token Price | Enter the 'Token Price', which is the advance payment for reserving the product. At present this functionality is being used in the case of 'Local Deals'. |
| Cost Price | Enter the 'Cost Price' of the product for your own reference here. |
| Hide Price | Enter Y to hide the price of this product on the storefront, else enter N. You can display 'Price on Request' Call for Action to reveal the price only to the interested customers. |
| Fulfillment Service Ref Code | These services are required for the fulfillment of a deal or online product deliveries (such as music, ringtones, movies, etc…). It's mandatory for Local Deals. Enter the applicable reference code here. |
| Section Ref Code | Enter the reference code of applicable 'Section page' to display 'Deals' & 'Deal Details' |
| Std Product Code | Standard Products are the products that can be identified internationally and are following specific International Standards for their identification. Enter the code as per the selected Std Product Type |
| Product Type - P (Product) or D (Deal) or A (Addon)* | Enter P or D or A for indicating whether this is a 'Product' or 'Deal' or 'Addon' respectively. |
| MPN | It is the Manufacturer Part Number (MPN), a unique part number given by the manufacturer. |
| Vendor | Enter the unique 'Reference Code' of the Supplier here if it a Supplier's Product. |
| Vendor SKU | Enter the SKU of the Supplier here if it a Supplier's Product. |
| Std Product Type | Standard Products are the products that can be identified internationally and are following specific International Standards for their identification. Enter the Standard Product Type as the ISBN 10 (International Standard Book Number) or ISBN 13 or UPC (Universal Product Code) or EAN (European Article Numbering) or GTIN (Global Trade Item Number) or ASIN (Amazon Standard Identification Number) as per applicability here. |
| Created Date | It refers to the date of product creation and it's auto-generated. The age of the product can be known from this date. Even if you enter some value here, it will be ignored. |
| Product ID | It's an auto-generated ID of the product. The 'Product ID' can be used to construct the dynamic URL for SEO purposes. Even if you enter some value here, it will be ignored. |
Add-on Products:
- Add-on products are the products which can't be directly purchased, they are add-ons of a specific base product and they should be purchased along with the mapped base product.
- For example, Meat, Veggie, Cheese, … which are the toppings for a Pizza. They can't be ordered independently. They can be ordered along with Pizza only.
- Add-on products can't find out in search results.
- You can create add-on products through Bulk Product Excel only i.e. ProductCatalogXXXXXXXXXXXXXX.xlsx. To add add-on products, enter A in Product Type - P (Product) or D (Deal) or A (Addon) column of ProductCatalogXXXXXXXXXXXXXX.xlsx file.
Normal Products and Deal Products:
- Note: Similarly, by specifying the P or D in Product Type - P (Product) or D (Deal) or A (Addon) column in the ProductCatalogXXXXXXXXXXXXXX.xlsx and uploading the same through the Bulk Product Upload interface, you can add the Normal Product or the Deal Product respectively.
2. How do I download the language sensitive product data of my store in a bulk quantity?
- To download required product data in a bulk quantity, do the following:
- Log in to the 'Anywhere Commerce Control Panel' by using your User Name (Email Address) and Password.
- You will be navigated to the Dashboard page.
- Click the icon. The Products section will be displayed as shown in the figure.
- Click Bulk Tools, and select Bulk Product Download. You will be navigated to the Bulk Tools > Bulk Product Download page. By default, the Store Category tab will be opened.
- Click Multilingual. The following section will be opened.
- To download the required product data, click Choose. You will be displayed a Select Category dialog box.
- The categories that are configured with your store will be displayed here. Select the required categories/sub-categories.
- Click Submit. The Select Category dialog box will be closed and the name of the selected Category (categories) will be displayed in the Category text box.
- Select the required language checkboxes for downloading the required multilingual product data.
- Click Generate File. The respective data will be downloaded and the download status will be updated in the run-time under the Import Tasks section.
- You can delete this task (if required) from the Import Tasks section by clicking relevant icon.
- To get the downloaded product data, click the icon of that respective download task under the Action column of the Import Tasks section. The ProductCatalogXXXXXXXXXXXXXX.xlsx file will be downloaded.
- To view and modify the product data, double-click on the ProductCatalogXXXXXXXXXXXXXX.xlsx file and the Excel will be displayed as shown in the figure.
- Note: The language code is mentioned under the Language Code column. Enter respective multilingual data in respective cells and save the Excel.
- You can refer the Definitions sheet to know exactly what each column of the Sheet1 denotes.