3dcart Walmart-Integration Documentation :: How to Sell on Walmart.com

Overview

Walmart Integration app by CedCommerce synchronizes 3dcart Store with Walmart. With the help of APIs provided by Walmart, the app creates a channel facilitating the synchronization of product inventory and orders, updating product's information and helps you manage the products from your 3dcart store itself.

Installation

Please follow few steps for adding Walmart-Integration app to your store.

For installing Walmart 3Dcart Integration app, visit Walmart 3Dcart Integration & click on "I want this App" option.

This will redirect you to the Cedcommerce site. Then click on "Add to Cart" button and then click on the cart to continue the process. (The app will ask permission for approving the data access of their 3dcart stores using API).

A) Adding Walmart-Integration Module

  • Click on Modules on the left panel.
  • Type Rest on the search option within the modules.
  • Click on Change Setting
  • Live API

    Rest API app page will appear. There is field for Public key, fill the public key that you had got through the mail. And then click on ADD button. to integrate the app with your store.

    Live API

    Login to your app


    After complete all the above steps you need to click on Walmart 3Dcart App to start the configuration of the app.

    registration-step Note: Remember the shop url and email that you will enter as it will be required every time when you will login to the app.

    Walmart Configuration Setup

    To successfully integrate your 3dcart Store with Walmart.com and to start selling on Walmart.com, few settings are required to be configured.

    Registration

    The first step of configuration process is the Registration step. In this merchant need to enter his personal details like: name, company address, revenue, e-mail, contact number, etc.

    registration-step

    Walmart Api

    To successfully integrate your 3dcart Store with Walmart and start selling on it, you need to provide Walmart Consumer ID and Walmart Secret Key.

    registration-step2 Thereafter, Click "Next" button.

    In order to obtain Walmart Consumer Id and API Secret Key the merchant needs to login to his Walmart Seller Panel. Click on the Settings icon > API option.

    configuration-settings-new

    Copy the “Consumer ID” and click on the “Regenerate Key” button to regenerate the secret key from your Walmart seller panel.

    configuration-settings-new1

    When you click on the “Regenerate Key” button then, a popup appears. Click “Yes, Regenerate Key” button, a new Secret Key is generated. live-api After that copy “Consumer ID” and “Secret Key” one by one, then paste these in the respective fields of the Walmart 3dcart Integration app’s configuration settings. live-api Now that 3dcart store is integrated with Walmart, importing products on Walmart from 3dcart Store is the third step.


    Product Import Section


    This step enables you to import products to your Walmart integration app.

    Here you get three options:

    All products: It enables you to import all the 3dcart store products in the app.

    Published products: It enables you to import only those products which are available at your 3dcart store’s front-end.

    Select products to import: It enables you to import only those product that you want. A table will be displayed listing all the products you can select any product to import.

    After selecting "All products" you will get the status of

    Product(s) Ready To import = Total Product(s) - Product(s) not having SKU

    Now Click on Start Import

    import-product

    Walmart Category Mapping


    On the left side of the screen is Product type (3dcart) and on right side Walmart Category Name. Map appropriate 3dcart product types with Walmart.com categories. Thereafter, provide appropriate Taxcode to each of the Product Type. Now that mapping is done, click NEXT.

    map-category-walmart

    Walmart Attribute Mapping


    Choose Walmart attributes that you want to map with your product variant options.


    Take Engagement Ring as a 3dcart product type for example:

    Now, in order to transfer correct information of your products on walmart, you need to map walmart attributes with your product variant options (attributes) .

    walmart-attribute-mapping

    Dashboard

    Dashboard of the app is full of features and also you can see products and orders, revenue of your store, various latest updates etc. It provides you the feature to communicate our team through various mediums. Dashboard

    Product Information

    You can see the status of your products with the help of this section. There are five status of products you can see-

    1. Published - Products which are live on walmart and available to sell will be listed in this section
    2. Item Processing - Products which are in processing state, it means after uploading your products they will be show in item pocessing state.
    3. Unpublished - Products which are rejected by walmart because of any issue like price factor etc will be show in this section. You can correct the particular error and then reupload them.
    4. Stage - If you did not perform test order scenario then after uploading your products they will be show in stage state.
    5. Not Uploaded - Products which are imported from app but not uploaded will be show in this section.
    Product Information


    Order Information

    You can get the information of your orders from here. You can see how much your orders are completed, how much are failed, how much are in progress etc. Order Information

    Products

    Now that categories and attributes are mapped, all the settings are completed now its time to upload the product on Walmart.com for sale.

    • In Walmart-Integration app,
      Go to the top menu and Click PRODUCTS -> MANAGE PRODUCTS.
    • You can see all the 3dcart store products that you imported are listed over here.
      Here all the different columns listed are self explanatory. See below.
    • 3dcart-product-listing

      In the above image you can see 5 buttons highlighted.

      Manual Product Import/Update: By clicking on this button you will be able to import or update all the product or single sku, by just entering the sku of that prodcuts.

      Update Price: By clicking this button your product price will be updated on Walmart.com. If you had updated price of any product of the product then click on "Update Price" it will sync your product price to Walmart.

      Update Inventory: By clicking on 'Update Inventory' your product(s) inventory will updated on Walmart.com

      Sync Status: By clicking on this your product status is 'synced' with walmart.com

      Get Promo Price Status: By clicking this button your product's promotional price status will be sync from Walmart.

      manage product list
    • NOTE:

      1) If there is any product without SKU, it will not be listed on App.

      2) Each variant must have unique SKU for every product.

      3) If merchant changed the SKU of uploaded product and again uploading same product ID but different SKU, then it might be conflicting SKU at the time of product upload. In this case you can set YES to SKU OVERRIDE and then upload that product).

      4) If you want to set the promotional price or the offer price to the product you an it be adding promotional price to the product. This will display the actual price and as well as the offer price of the product on Walmart.

      5) Product price must be assigned to each product. Product price cannot be 0. You can update product price by admin panel of 3dcart.

      6) You can also add Shipping Exception to products individually by clicking on Add Shipping Exception on Product Edit

    • Now to update any information of products,
      Click EDIT icon of the product. You can see many editable and non editable fields.

    • Configure Simple Products (Non Variant)


    • attribute-nonvariant As visible in the image above, the product has NO variations, the product can be uploaded directly.

    • Configure Variant Products


      Those products having different variations are called Variant Products. attribute-variant-new The attributes of the products are updated, again, as per walmart.com’s category. As Variant Product is selected, it shows variable attribute listings. There are 3 products listing in the above image, first is the parent product and the other 2 are the children products.

    • Promotional Pricing


    • If you want to add the offer price or the sale price then you can set it by adding the promotional price of that particular product. You can do it by clicking the Edit button of that particular product.
      Then click on Add Promotional Price a popup box will appear.
      Set the offer price and date for that offer. Then click "SAVE". attribute-nonvariant


    • Walmart Taxcode

      Select appropriate taxcode to you product type from here. status_bar


      Upload Products

      Select the product, choose upload and Click Submit. product-mass-upload-new Upon selecting and uploading the products, the next page appears with PRODUCT UPLOAD. Product. Upload will show the Number of products successfully uploaded and Number of Products having ERRORS. Furthermore, Errors can occur due to DUPLICATE SKU(s) or Barcode, MISSING Image, INVALID Quantity and IMPROPER mapping of 3dcart variant options with walmart.com’s attributes. For batch upload, errors are displayed for each product if any product has incomplete information. To describe the error for each products in brief, see the image below.

      If product has all the information valid, it gets uploaded on walmart.com and STATUS changes from "Not uploaded" to "Item Processing" or ERROR ICON gets displayed in action column.


      Walmart Product Feed

      After Uploading the products, second task is to Update Feed Status. The data is sent to Walmart.com in the form of feed, so we need to update the feed status.
      Select the feed by ticking the check boxes,
      Then select the "Update Feed Status".
      Click on SUBMIT button. status_bar Thereafter, click on Sync Status to get the status of the products.


      Order Management

      Under order management section, all the details of Walmart orders, whether it's Acknowledged, shipped, returned or refunded are stored.

      Note: Only the READY orders will be imported onto Walmart 3dcart Integration app.

      If any new orders are created on walmart.com, they are instantly fetched by our app. Same order is generated for the 3dcart store if you have set "YES" to Sync Order on 3dcart, for merchants to view details and fulfill them easily in their native order processing system.
      To view all the imported orders from our app.

      Sales Orders

      Walmart orders can be viewed under sales order area in the app. To check order details, Go to top menu Orders ->Sales Order. order-listing

      Failed Orders

      In the case quantity is not available in 3dcart store or product SKU doesn’t exist) app does not fetch order from walmart.com. For checking details of failed orders
      Open Orders -> Failed Order section. failed-orders-list

      Import / Export

      Under Import/Export section, can make changes in bulk by Exporting the CSV file and then importing it.

      Product Update

      From here you can Export the CSV file and make changes in product information. Note: Do not change the product ID.
      Click on Export button to Export the CSV file in which you will make the changes.
      Click on Browse button to select the edited file.
      Click on Import button to upload the edited file. order-listing

      Retire Product

      From here you can Retire the that you do not want on walmart anymore.
      Click on Export button to Export the CSV file in which you will make the changes.
      Click on Browse button to select the edited file.
      Click on Import button to upload the edited file. order-listing

      Walmart Settings

      Walmart Configuration Setting

      Here you can view all the configuration setting that you had filled at the time of doing configuration. walmart-attribute-mapping

      Billing Payment Method ID

      To create the order at the 3dcart store via 3dcart api you need to have Offline Payment Method ID. walmart-attribute-mapping Steps to get the Payment Method ID:
      To get it, log in to your 3dcart store
      1. Go to settings
      2. Then click on Payment.
      walmart-attribute-mapping
      3. Click on "Select Payment Method"
      walmart-attribute-mapping
      4. If you have already selected any then just hover on Exclude list and if not selected the click on add new.
      walmart-attribute-mapping
      5. Select any offline method and then click on Add New.
      walmart-attribute-mapping
      6. After adding the payment method, click on Exclude List.
      walmart-attribute-mapping
      7. After that you will be able to see the payment method id in the URL of that page.
      walmart-attribute-mapping

      Walmart Return Location

      walmart-attribute-mapping

      Product Settings

      If you want increase or decrease the price of all the products by same amount or percentage then you can do it from here.
      You can do it by selecting YES
      > then Select Increase Price or Decrease Price.
      > then select whether you want to change the price in Fixed Amount or in Percentage.
      > Set the fixed amount of percentage by how much you want to change the price. walmart-attribute-mapping You can also set the Threshold Limit here, by setting the minimum limit after that you will get the notification on the dashboard.

      Call Schedule

      walmart-attribute-mapping

      This will help you to schedule a call at you best time. A person will assit you and answer all your queries.

      walmart-attribute-mapping

    $(document).ready(function(){ showfeedback(); $('#hide').click(function(e){ if($('#i_tag').attr('class')=='glyphicon glyphicon-chevron-right'){ $("#i_tag").attr('class', "glyphicon glyphicon-chevron-left"); } else{ $("#i_tag").attr('class', "glyphicon glyphicon-chevron-right"); } $('#feedback').toggleClass('show'); e.preventDefault(); }) }); $(document).ready(function () { $('.dropdown').addClass('dropdown1').removeClass('dropdown'); }); $("#show_apps_div").click(function () { var x = document.getElementById('display_apps'); if (x.style.display === 'none') { x.style.display = 'block'; } else { x.style.display = 'none'; } }); $('.fixed-container-body-class').on('click', '.confirmbox .btn.btn-primary', function (e) { var lastclass = $(this).attr('class').split(' ').pop(); if (lastclass != 'noconfirmbox') { e.preventDefault(); var url = $(this).attr('href'); alertify.confirm("Click OK to continue for " + $(this).text() + "?", function (e) { if (e) { window.location = url; } else { } }); } });