Read More
Read More
Menu Close

    Opencart Amazon Connector

    Opencart Amazon Connector integrates the Amazon store with the Opencart store. With the help of this extension, the store owner can import products, orders, and customers from Amazon to Opencart.

    Meanwhile, the extension also enables the store owner to export its products from Opencart to Amazon. Opencart Amazon Connector performs real-time updates of synchronized products price and quantities on the Amazon store.

    Note: To obtain the Amazon MWS credentials, you need to complete the Developer Registration and Assessment, and only after that, you will receive the Amazon MWS Access keys. Webkul will not be held responsible for obtaining/generating the credentials.

    Here understand of the extension workflow:-

    O9sQTbcEIxA

     

    Features

    • Connect multiple Amazon seller accounts with Opencart.
    • Set default quantity and weight of import products.
    • Select the default Opencart store for order sync and import products.
    • Update import and export products’ prices & quantities on Amazon.
    • Select the default Opencart order status of Amazon orders.
    • Add custom price/quantity rule for the import/export products.
    • Provide the currency exchange rate of the Amazon store.
    • The admin can check the feed status of export products.
    • Import the Amazon orders according to date or order ID.
    • View the customer data (name, address, email) from the Amazon orders.
    • Import the Amazon product using ASIN (Amazon Standard Identification Number).
    • Export Opencart Un-mapped products to Amazon Store through the cron job
    • Update Map product stock, price, and product image according to their Sync Source through a cron job.
    • Admin can set the images as per the product variations.
    • The source code is open for customization.

    This module will work only in the region that’s listed on this page: https://docs.developer.amazonservices.com/en_US/dev_guide/DG_Endpoints.html 

    Installation

    Upload Files of Opencart Amazon Connector

    First, extract the download zip file. After that, open the correct Opencart Version Folder. According to Opencart Version install in the system. After that, upload admin, lib, catalog, and system folders and cron files to the Opencart root directory.

    Searching for an experienced
    Opencart Company ?
    Read More

    amazon_install

    Upload XML

    After that, log in to the admin backend and navigate to Extensions > Installer. Click the Upload button and browse the XML file, this file is in the ocmod folder. Please select the correct ocmod folder. According to the Opencart version install it on your system.

    Extension-Installer

    Click Continue after uploading the XML file.

    Refresh Modifications

    After uploading the XML file, please navigate through Extensions>Modifications. Now click the Refresh button as visible in the below screenshot.

    Modification

    Edit User Groups

    Furthermore, go to System>Users>Usergroups. And then edit ‘Administrator’. Click Select All for both Access Permission and Modify Permission and Save it.

    User-Groups

    Installation: Opencart Amazon Connector

    After that, navigate to Extensions> Extensions > select Module from the dropdown. Find Opencart Amazon Connector from the list. Click the Install button as visible in the screenshot below.Extensions

    How to Add Cron Job:

    By using a cron job, all new add Opencart products will export only to the first add Amazon seller’s account.

    1)Go to your Cpanel and click on cron jobs under Advanced.

    2)Move to Add New cron job, select common settings, and set your time when you want to run the cron file.

    3)Go to command and add your path where amazon_cron.php exist.
    ex- public_html/opencart_root_directory/amazon_cron.php.

    4)Click on “Add New Cron Job”.

    How to Get Amazon Credentials?

    1: Log in to your account at Amazon Seller Central and then navigate through Settings->User Permissions.

    seller_central_settings_user_permissions

    2: Now the section that appears, navigate to the Amazon MWS Developer Access Keys and tap the Visit Developer Credentials button to register as a developer or to view your Access keys.

    seller_central_settings_amazon_mws_developer_credentials

    3: On the Developer Central page, you can apply for MWS API Access Keys by tapping the link “apply for access here“.

    developer_central_access_key_application

    4: Now, the section that appears tap the “Proceed to Registration and Assessment” button.

    proceed_to_registration_and_assesment

    5: Lastly, to get the Seller ID, navigate to Settings -> Account Info. Here, under Business Information tap the ‘You Merchant Token‘ to get your seller id.

    Settings_account_info

    Module Configuration

    To do the module configuration, go to Extensions>Modules>Opencart Amazon Connector and click Edit button.

    Extensions-1

    The following page will open, and set the Status option as Enabled to use Opencart Amazon Connector. Else select Disabled if do not want to use this module. Opencart-Amazon-Connector

    General Options

    Choose Default Category – Select the default Opencart category for the Amazon products where they will get imported.

    Default Product Quantity – Set the default quantity of Amazon and Opencart products that have zero quantity. After exporting or importing zero quantity products, this value will become the quantity.

    Amazon Product Weight (in Grams) – Enter the default weight of those Amazon products which have no weight.

    Opencart Un-mapped Product to Amazon(through Cron Job) – If “enabled” the unmapped product will get export to Amazon from the first Amazon Account only.

    Update Mapped products (through Cron Job) – If “enabled” then you can update the mapped product quantity and price according to their synchronization source.

    Opencart-Amazon-Connector-1-1

    Order Options

    Default Store for Order Sync – Select the default Opencart store for importing Amazon orders.

    Amazon Imported Order Status – Select the default order status of the Amazon orders.

    Opencart-Amazon-Connector-2

    Product Options

    Default Store for Product – Select the default Opencart store where Amazon products will be import. The selected store will be assigned to all the Amazon imported products.

    Product Variation (Option) Choice – Select Option 1 for importing every product from the Amazon store including the variations/options.

    Note – Each variation/option will be created as a separate Opencart product.

    Else, select Option 2 for importing only those Amazon products which do not have any variations. The Amazon products which have variations/options will not be imported to Opencart.

    Opencart-Amazon-Connector-product3

    Real-Time Update Settings

    Further, if the store owner changes the price or quantity in Opencart, it can update on Amazon automatically using the following options:

    Update Imported Product on Amazon Store – Set On to do a real-time update of imported products’ price and quantity on Amazon.

    Updated Exported Product on Amazon Store – Set On to do a real-time update of exported product’s price and quantity on Amazon.

    askb

    Price/Quantity Rules Settings

    Price Rule For The admin can select whether the price rule should be applied for the Imports or Exports.

    Quantity Rules For Imported Products: If “enabled” the quantity rule will be applied for the Imported products.

    Quantity Rules For Exported Products: If “enabled” the quantity rule will be applied for the Exported products.

    Opencart-Amazon-Connector-3

    Manage Amazon Accounts

    Amazon Accounts List

    After doing the module configuration, the store owner needs to add Amazon account credentials. Go to Opencart Amazon Connector>Manage Amazon Accounts.

    The following page will open showing Amazon accounts list with the Account ID, Store Name, Marketplace ID, Seller ID, and Added Date.

    Add Amazon Account – Click this button to add a new Amazon account for synchronization.

    Delete – Click this to remove an existing Amazon account from the list.

    Edit – Click this to manage the Amazon account and do synchronization.

    Amazon-Accounts-List

    Add Amazon Account

    After clicking Add Amazon Account button, the following page will open. The store owner needs to provide the following information:

    Store Name – Enter the Amazon store name.

    Select Attribute Group – The admin can choose an attribute group for this account.

    Marketplace ID – Enter the marketplace ID according to the region.

    Seller ID – Enter Amazon seller account seller ID here.

    Access Key ID – Enter Amazon AWS Access Key ID here.

    Secret Key – Enter Amazon developer secret key here.’

    Amazon MWS Auth Token- Enter the Amazon MWS Auth Token key here. 

    Origin Country – Select Amazon store country.

    Currency Rate – Enter the exchange rate of Opencart store currency to Amazon store currency. Enter 1, if both stores are in the same country.

    Add-Amazon-Account

    Products Mapping

    To do the mapping of products, go to Opencart Amazon Connector>Manage Amazon>Accounts>Edit>Map Product. The following page will open showing the imported Amazon product list with Map ID, Opencart Product ID, Product Name, Amazon Product ASIN, Sync Source, Price, and Quantity.

    Import Product – Click the Import Product button for importing products from the Amazon store to the Opencart store.

    Update/Delete Exported Products – Click on this button for updating/deleting in already exported products on Amazon.

    Delete Product – Click the delete Product button for removing the existing mapped product record from the list.manage account

    Import Products from Amazon Store

    After clicking the Import Product button, the following page will open. Moreover, click Generate Report ID, and importing process will start. It will import the Amazon product’s names, price, weight, specifications, quantity, main product image, and description.

    Edit-Amazon-Account-1-2

    After that, generating the report ID, a success message will appear:

    selection_18967902689285

    Further, to import products from Amazon, click the Import Amazon Products button and the products will start import to the Opencart database.

    Meanwhile, if the products are already added to the database then the existing products will be updated.update imported product

    Further, or creating/updating imported products, the admin will click on Create/Update Imported product button. After successful creation/updation of the product, it will give a success message.

    success message

    Mapped Product Listing

    Under the following section, the admin can Map Products for the already existing products. This will allow the admin to update the existing products by clicking on the “Map Product” button as shown in the image below.

    Amazon item

    After clicking on the “Map Product” button, a Pop Box will appear on the page where the admin can enter the product that is to be mapped after this a successful message will appear in the back end.

    Successful message

    The products with variations are listed under the “Variation List” tab which will display the variations of all the products. Edit-Amazon-Account-1-1

    Create/Update Amazon Store Products By ASIN

    To create or update products using Amazon product ASIN ID (Amazon Standard Identification Number), click Create/Update Amazon Products By ASIN button. A small pop-up window will appear.

    Enter the Amazon Product ASIN value and click the Import Product button. Only one product at a time can be imported using ASIN.

    Amazon ASIN

    Update/Delete Exported Products to Amazon Store:

    The admin can update or delete exported products to the Amazon store. The admin needs to select a product first.

    After that, the admin needs to click on the Update Exported Product button for updating exported products and the Delete Exported Product button for deleting exported products to the Amazon store.

    Update/delete exported productsSuccess Result: After clicking on “Update Exported Product” OR “Delete Exported Product“, the admin can view a success message with a total number of products updated/deleted to the Amazon store.

    success message

    Import Orders: Opencart Amazon Connector

    To import orders from Amazon to Opencart, go to Opencart Amazon Connector>Manage Amazon Accounts>Edit>Map Order.

    The following page will open, showing an import Amazon orders list mentioning Map ID, Opencart ID, Amazon Order ID, Buyer Name, Buyer Email, Amazon Order Status, and Order Total.

    Import Order – Click the Import Order button to fetch orders from the Amazon store to the Opencart store.

    Delete – Click the Delete button, to remove the records of the mapped order from the list.

    Filter Order: The admin can apply the filter to orders as per their requirement like Amazon order-id, buyer name, buyer email, order total, Amazon order status, date added, and Opencart order-id options.

    Edit Amazon Account

    Import Orders from Amazon

    After clicking the Import Order button, the following page will open. Click the Generate Report ID Before Sync Orders button.

    class style=”color:blue”Note :

    1. It can only import Amazon orders which are either shipped, unshipped, or partially shipped.
    2. It can import only those orders which were created a day before the Report ID was generated.
    3. If the store owner has selected Option 2 for  Product Variation (Option) Choice in Module Configuration, then orders containing product variations will not be imported.
    4. After importing the orders from Amazon, the products in the order will also be imported to Opencart.

    Generate report id

    After that, generating the report ID, a success message will appear. Now, click the Import Amazon Store Orders button and it will import orders to the Opencart database.

    Moreover, for creating imported orders to the Opencart store, the admin needs to click on “Create Imported Amazon Order“. It will create orders in the Opencart store according to the dates.

    After that, the admin can import orders through Order-ID. The admin needs to click on Import Amazon Store Orders By Order-ID button to fetch orders using the Amazon Order ID.

    create imported amazon order

    Enter Order Details

    Whereas, when the admin will click on “Import Amazon Store Orders” then the admin needs to select from which date to fetch the Amazon orders.

    enter order details

    Create Imported Amazon Order:

    Therefore, this button will create all the imported orders from Amazon to the Opencart store order tab. It will give a message after creating the product.

    successful import amazon order

    Sync Amazon Store Order By Order ID

    Whereas, enter the Amazon Order ID to fetch and click the import Order button. Also,  only one order at a time can be imported from Amazon to Opencart.

    sync order amazon by order id

    Order View

    Although, after importing the orders from the Amazon store, the admin can view the Amazon orders in the Opencart store-backend. In the Order Details, the Amazon shipping will be displayed as shown in the sample order imported from the Amazon store.

    Amazon shipping

    Amazon Customers

    The store owner can fetch the customer data from the Amazon store to the Opencart store by importing orders. To view the Amazon customer data, go to Opencart Amazon Connector>Manage Amazon Accounts>Edit>Amazon Customers.

    Moreover, the following page will open showing the list of all the Amazon customers whose orders have been synced with the Opencart store.

    Note:-

    1. Amazon customer data is fetched from the orders. So, it is essential to import the orders first.
    2. It will import the customer’s name, email, address, pin code, city, and country.

    Synchronized Customer

    Furthermore, the store owner can view Amazon customer information in the Opencart backend. It can view the name and e-mail.

    Customers

    Moreover, it will also fetch the customer’s address, city, pin code, and country from the orders.

    Customers-2

    Export Products to Amazon Store

    Whereas, for exporting products from Opencart to Amazon, the admin needs to navigate Opencart Amazon Connector>Manage Amazon>Accounts>Edit>Export to Amazon. 

    Note: 

    1. Disabled Opencart products will not export to Amazon Store.
    2. Although, exported products must have the ASIN (Amazon Standard Identification Number) including the variations.
    3. Additionally, When the admin will update the exported product in Opencart, only the price and quantity will update on Amazon.
    4. Amazon product ASIN will be mapped to Opencart product ID.
    5. If a product has a combination or variation in Opencart, then each combination or variation will be exported as an individual product on Amazon.
    6. Therefore, Opencart Amazon Connector will export the product’s name, price, quantity, SKU, description, and variations (If Any) on the Amazon store.

    Action for Export Products to Amazon:

    Whereas, the admin needs to select the product from the product list under the Store Product List menu. After selecting the products, the admin needs to click on “Export Products to Amazon”. After clicking on it, if the product is successfully export to Amazon then the admin can see a successful message “Opencart product synchronization process has been complete to Amazon”. 

    Edit-Amazon-Account-2

    Show Result:

    After that, by clicking on show result button, the admin can see all messages (success or warning) in a pop-up.
    product export amazon

    Product Review

    After that, the products are export to Amazon, there may take time to get displayed on Amazon. The admin can check the “Feed Status” of the product that is export as shown in the image below.

    selection_18967902689286Moreover, if the product will export successfully then a successful message appears as shown in the image below.

    selection_18967902689287

    Manage Price Rules

    Whereas, the Admin can manage the price/quantity rule under the following tab as shown in the image below. Where the admin can add or edit the price/quantity rule.

    Amazon-Price-Quantity-Rules-List

    After that, the Admin can enter the price rules or can upload a CSV file for multiple rules. New rules can create by clicking on the “Add Price Rule” Tab as shown in the image below:

    Add-Price-Quantity-Rules

    Thus, there are rule types mention below:- 

    Rule Type: The Rule can be of two types:

    1. Price
    2. Quantity

    Price Rule From: The minimum price amount for which the rule will be applicable.

    Price Rule To: The maximum price above which the price rule will not be applicable.

    Amount Value: The quantity for which the rule will be applicable

    Therefore, Operation Type: The admin can select which operation type is require( Incremental or Decremental).

    Operation: The price of the operation can be either fix or in percent.

    Price Rule Status: The admin can select the price rule status as enabled or disabled.

    Therefore, the admin can mass upload the price rule by uploading the Price Rule CSV file. You need to select the Upload CSV button. A new page will appear with the following options.

    Rule Type: The admin can select the rule (Price/Quantity).

    Additionally, Enter CSV File: The admin can upload the CSV file for the price rule, with the proper file format as defined in our sample CSV file.

    Add-Rules-with-CSV-file

    Amazon Add Map Product Data

    Although, when the store owner has successfully imported the Amazon products, it will find the Unique Identification Number, Specifications, and Variations (If Any). This information will be visible on the Opencart store front-end.

    After that, under the Map Product Data, the store owner can add new Map Products as shown in the image below:

    Amazon-Map-Product-data

    Amazon Product Authorization

    After that, to view or edit the product which is the map, go to Map Product Data>Add Map Product>Amazon Product Authorization. The following page will open as visible below:

    Amazon-Map-Product-1Unique Identification Number – UIN (Unique Identification Number) helps in identifying the product. Each product will have its own UIN. There are different types of UNI are in use by different regions such as: –

    ASIN – Amazon Standard Identification Number.

    EAN – European Article Number.

    GTIN – Global Trade Item Number.

    UPC – Universal Product Code.

    Additionally, an Identification Number –  UIN generally consists of a 10-12 digits alpha-numeric code that identifies an item.

    Note – Before exporting product any product to Amazon, the store owner must provide a Unique Identification Number for each product.

    Amazon Specification

    Therefore, the admin can add the specification to Amazon,  go to Add Map Product>Amazon Specification. The following page will open. After successfully importing the products from the Amazon store, specifications and values will be retrieved. The store owner can edit, add, or remove the specifications and their values.

    Note : 

    1. The Amazon Specifications and their values will be visible on the Opencart store front-end.
    2. If the store owner edits or updates any specification in Opencart, it will only reflect on Opencart store front-end.

    Amazon-Map-Product-2
    Amazon Combination/Variation

    Therefore, the admin can add the variations or combinations to the products, go to Add Map Product>Amazon Combination/Variations.

    Although, the admin can select the variations and can set the SKU, ID type, Quantity(specified for that particular variation), Price prefix(+/-), and Price Amount(added/subtracted from the product price).

    Amazon-Map-Product-4

    Map Details

    Whereas, the store owner can view the Mapped Product details by navigating to Catalog>Products for all the products that will import from Amazon as shown in the image below.

    Store-image

    Thus, the store owner can view the store name along with the Amazon product id and its source. On selecting the store under the Map Details the owner will redirect to the Edit Amazon Account page.

    Front-End View of Opencart Amazon Connector

    Amazon Store View of Opencart Amazon Connector

    Moreover, please view the below screenshot, where the store owner is importing the product from Amazon to the Opencart store.

    front view

    Opencart Front-End View

    After that, successfully importing the product from Amazon, it will appear as follows. It will show the product name, image, price, description, specifications, stock, and variations.

    Therefore, if products with variables are selected then the respective image for that variable is displayed. Consider a product with variation as shown in the image below.

    before variationAfter that, the customer can select the variation, then the variation also changes along with the respective image that is uploaded for that particular variation.

    after variation

    Lastly, thank you for viewing this blog. If you have any queries regarding this module, please contact us at webkul.uvdesk.com.

    Current Product Version - 3.6.0.8

    Supported Framework Version - 2.x.x.x, 3.x.x.x

    . . .
    Discuss on Helpdesk

    Leave a Comment

    Your email address will not be published. Required fields are marked*


    Be the first to comment.

    Back to Top

    Table of Content