Open Cart - Provides an e-Commerce platform that connects products and public. Now Open Cart integrated with linnworks allows you to manage orders and inventory from linnworks.

This integration support Opencart Version 2.3.0.2

Order Management:
Order download to linnworks
After Order process in Linnworks dispatch notification transfer to Open Cart.

Inventory Management:
Define mapping of Open Cart products and Linnworks
Stock update from linnworks to Open Cart

Price Update:
Manage product price from linnworks to Open Cart

Packages available (ex vat): £24.99 + VAT/ per month

Product Listing: List products from Linnworks to Open Cart

Integrate the Channel into Linnworks.net

To use Open Cart channel, you must first install it from within Linnworks.net.

  • Login to Linnworks.net
  • Select Settings in the left-hand menu bar

  • Select the Channel Integration option.
  • Select Add New to return a list of available Channel Integrations.

  • Locate OpenCart on the list, and click on Integrate.

  • After reading the warning, please click on Accept to move onto the next step of the integration. You can click on the link at the bottom to review the Opencart Channel Terms and Conditions first, if you opencart to.

  • Enter your opencart account name to start the actual integration. And then click on next button for the next step.

  • After reading the Disclaimer, please tick ‘I agree to the terms and conditions’ and Next to continue integrating opencart.

  • OpenCart Integration Guide :

    This integration support Opencart Version 2.3.0.2

    To integrate your opencart account, you will need the following information :

    • Personal Access Token :
      • If you are not already logged in then will be asked for login. Enter your login credentials of your Seller / Merchant Account.
      • Click on Login.
      • Step 1: Install Extension



        1. On the left menu expand Extensions menu.
        2. Click on Extension Installer to open the Extension Installer page.
        3. Click on upload button to select extension. (Notes: for download extension click here). If Extension successfully upload then it will show the list of file which is overwritten and also continue button will be enabled.
        4. Click on continue button to finish installation.

      • Step 2: Enabled Extension

        1. Open Extensions page with following steps



        2. In Extensions page follow below steps.



        1. Select extension type (Feeds).
        2. Inside that install GSS API by click on “+” action button.
        3. After successfully installation click button to enable this api.
        4. It will open the bellow screens. In that select status enable and save it.

      • Step 3: Create API Access

        1. Open APIs by System->Users->Api
        a. In that click on “+” button to add new access



        b. On click on “+” button it will open the bellow screens.



        i. Give the API Name as Linnworks.
        ii. Click on Generate button to create API Key.
        iii. Select status as Enabled
        c. Click on IP Address Tab to add over ip to access opencart api.



        i. Click on IP Address Tab.
        ii. Click on “+” button to add new IP.
        iii. Enter “52.91.17.49” and “202.131.103.122” IP.
        iv. Click on save button to save api configurations.

    • Please copy and paste these into the Opencart integration API Settings.
  • Select the order status which type order downloaded in Linnworks.Net from Opencart. After that click on next button.

  • To complete the integration, please click on Finish. Your OpenCart integration should now show in Linnworks.Net  Channel Integrations.

Edit Channel Details

  • Account Status
    • In Linnworks .Net, select Settings.
    • Select Channel Integration.
    • Locate the opencart entry, and look to the right. Click on the Configuration button.
    • To Enable or Disable the Account, locate the Account section.
    • If the Enabled option is not ticked, the channel will not download or update orders, or provide inventory level updates.
    • The Test button allows you to confirm there are no errors preventing Linnworks and opencart communicating. Contact EBG Support if Test Reports any errors.
    • Click Save at the bottom of this window to apply any changes.

  • Channel Inventory Settings
    • In Linnworks .Net, select Settings.
    • Select Channel Integration.
    • Locate the opencart entry, and look to the right. Click on the Configuration button.
    • In the Inventory section, the first entry is Update Inventory. If this is disabled, then Linnworks will not tell the listings on the opncart marketplace when Available Stock Levels change in Linnworks. If enabled, then Linnworks will provide these updates.
    • Update Inventory only works where a listing has been mapped to a Linnworks Inventory item. See the end of this document for more information on Mapping.
    • The Price Change feature allows Linnworks to send new prices directly to the listing when they are correctly imported or updated.
      a. Price Change only works where a listing has been mapped to a Linnworks Inventory item. See the end of this document for more information on Price Change and Mapping.
    • Max Listed allows you to filter the highest quantity that Linnworks can/will send to the listings on this opencart channel. If Max Listed is set to 50 and your Available Stock moves from 30 to 60, Linnworks can only send 50, and this will not change until the Available Stock level drops below 50.
    • Stock Percentage acts in a similar fashion, but only updates the listings with the specified percentage of your actual Available Stock level.
    • End when allows you to set a ‘false zero’ for the channel. This means it will send Out of Stock when the available stock reaches the value set in this value.
    • Click Save at the bottom of this window to apply any changes.

  • Channel Listing Settings

    Linnworks.net periodically checks the channel for the current listings you have on the channel, their titles and SKUs, so that the Mapping Tool can be used correctly. It can be triggered manually, should you have made changes directly on the channel and outside of Linnworks.

    • In Linnworks .Net, select Settings.
    • Select Channel Integration.
    • Locate the opencart entry, and look to the right. Click on the Configuration button.
    • In the Listings section, the information reflects the information Linnworks currently has about your listed items on the opencart marketplace.
    • 5) If there is a tick by listing download in progress, Linnworks is downloading the current listings, and cannot be interrupted.
    • The Listing download start time value is the time the last download/update was started.
    • The Last listing download completion time value tells you the last successful download completed and was imported into Linnworks.
    • The Listing download estimated completion reflects Linnworks’ best estimate of when the most recent or current download should complete. The Download Listings button instructs Linnworks to retrieve the latest listing information, and ticks the Listing Download in Progress box. This can only be used once every 4 hours maximum, and will warn you if you try to use it more frequently.
    • Click Save at the bottom of this window to apply any changes.

  • Order settings

    This section reflects activities affecting the Linnworks Order Sync on your opencart channel integration. Linnworks downloads orders from opencart with the status shipping in Progress.

    • In Linnworks .Net, select Settings.
    • Select Channel Integration.
    • Locate the opencart entry, and look to the right. Click on the Configuration button.
    • In the Order section, there are 2 options.
    • Despatch Notes, when enabled, allows Linnworks to send information about orders that have been processed in Linnworks. Orders that are processed in Linnworks updated to the open cart , as per your selected status on Process orders status at configuration part.
    • The Order Sync Date reflects the date and time of the last successful order download and update for the current opencart channel integration.
    • Click Save at the bottom of this window to apply any changes.

  • API Settings

    These settings are used to enable Linnworks and your opencart account to connect, and are covered in Step 1.

    Click Save at the bottom of this window to apply any changes.

  • Mapping

    Linnworks.net uses the Mapping Tool to ensure that it knows which SKUs in its inventory are connected to which listings on opencart. As such, you should ensure that all of your listings are mapped correctly, or stock levels and prices will not update correctly, and orders may not be picked accurately.

    • In Linnworks .Net, select Settings.
    • Select Channel Integration.
    • Locate the opencart entry, and look to the right. Click on the Mapping button (see above).

    This screen is divided into 2 sections.

    On the left is the listing Linnworks is aware of on your opencart Channel. If this is not correct, or a change is missing, you should see the Download Listings button in the Listings section of the Channel Configuration.

    On the right is a Linnworks Inventory Search Tool.

    Each has its own Search box.

    In the bottom left hand corner of the window is a status section. It shows the Total number of listings on the channel, and then beside it the Unlinked and Linked numbers – Linked listings are connected to a Linnworks Inventory item to allow updates and recognition, Unlinked are not. Ideally there should be no unlinked listings.

  • Linking items Automatically

    If the SKUs in your inventory match the SKUs used on the listings, you can ask Linnworks to link them all for you.

    • Click the button in the top left hand corner with a gear on it.
    • Select Link all by.
    • Select SKU.
    • Linnworks will map all those listings that have a SKU which matches a SKU in the Linnworks Inventory.
    • Check the Linked and Unlinked values once this is complete.
  • Linking Items Manually

    If the SKUs in your inventory do not match the SKUs used on the listings, you can make the link manually.

    • Use the left hand list and Search to find the listing to be linked.
    • Click on it to highlight and select it.
    • In the right hand list, use the Search box to find the correct Linnworks Inventory item to link it to.
    • Click on the Link button beside it with the listing highlighted.
    • Repeat for other listings to be linked manually.
  • Creating Linnworks Inventory items and mapping them

    If there are no SKUs in your inventory match to the SKUs on the listings, you can ask Linnworks to create basic Inventory items for you, and link them.

    • Use the left hand list and Search to find the listing to be linked.
    • Click on the Create button.
    • A new item will be created in the Linnworks inventory using the Name, Price and stock level, as well as the SKU from the listing. This will be linked to the SKU.
    • This can be updated with other information later in the Inventory.
    • Repeat this for other Listings that have no Linnworks inventory equivalent.
  • Price Change Functionality

    Price Change only works for listings that are correctly linked to a Linnworks Inventory item in the Mapping Tool.

    • Open Linnworks.Net.
    • Select Inventory.
    • Select My Inventory.
    • Use Search to locate the Inventory item that requires a Price Change on opencart.
    • Click on the SKU to edit the item.
    • Click on the Listing descriptions tab.
    • Under the Product pricing by channel section, click on Add New.
    • Enter the Source as opencart.
    • Enter the Sub Source as the account name of the opencart channel.
    • Enter the Price.
    • Click on + add to complete.
    • If there is already an entry present for the correct Source and Sub Source, double click the Price to edit it, and then hit Enter.
    • Close the SKU window when you have finished.
Location Mapping

  • In Linnworks .Net, select Settings.
  • Select Channel Integration.
  • Locate the opncart entry, and look to the right. Click on the Configuration button.
  • Locate the Location Mapping button, and click on it.
  • This opens the Location Mapping window.
  • The first option is the Order Download location. This is initially Default, but can be changed. Click on the dropdown list and select which inventory/fulfillment location will initially receive the orders from this opencart integration.
  • Under Inventory Sync Locations, you control which Linnworks Inventory locations are used to calculate the Available Stock values for your opencart listings.
  • If you have only the Default location, this can be ignored, with Default left enabled.
  • If you have multiple Inventory Locations, you can switch off locations (Slide switch to the left) that you don’t want to be included in the stock numbers on the listings.

Click Save when you have finished updating Linnworks. You should also click Save at the bottom of the configuration window to apply any changes.

Shipping Mapping

Once order process in linnworks – postal service name and tracking number transfer to that order  Order History in open cart.

For reference please check attached snapshot:

Payment Mapping

  • In Linnworks .Net, select Settings.
  • Select Channel Integration.
  • Locate the opencart entry, and look to the right. Locate the Payment Method button (see above), and click on it.
  • This opens the Edit Payment Methods window; the list will initially be blank.
  • When mapped, Linnworks will ensure the orders it downloads from opencart reflect correctly which payment methods/providers have been used on the site.
  • Click Save at the bottom of the channel integration window to apply any changes.

  • Map Opencart Payment Methods

    • Select the Channel Payment Method value, and select one of the Payment Methods from opencart that show in the dropdown list.
    • Then click on the Linnworks Payment Method dropdown. Select the appropriate Linnworks Payment Method that should be used in Linnworks orders when they are downloaded including the above payment method.
    • Press Add to save the mapping, and return to the list.
    • Repeat this for all of the opencart payment methods that are being used by you.
    • Click Save at the bottom of the channel configuration window to apply any changes.
OpenCart Product Listing

Requirements:

Your OpenCart channel must be integrated in Linnworks.net

The Channel Name (Sub Source) used while integrating Opencart must be defined as an Extended Property of all items you wish to list using the integration. An example of this is shown below:

o Property Name: oc_ind02 (Name of the SubSource)
o Property Value: true
o Property Type: Attribute

Each product must have at least one image in its Linnworks Inventory entry. This can include linking to a remote image using Extended Properties
(https://help.linnworks.com/support/solutions/articles/7000010167-using-extended-properties-to-work-with-images-already-hosted-online).

The Stock Level must be greater than 0.

The Default or specific Price must be greater than 0.

Steps for using OpenCart Product listing:

1. Once aOpenCartchannel is integrated in Linnworks, you can open the Apps button to show the currently installed Apps list as well as the Application Store entry. You can select the OpenCartlisting option to proceed.

2. Once opened, main screen will be displayed as below:

2.1 Before starting product listing we have to add configurations. For that please click on configurations button.

2.1.2 You’ll be shown a list of all currently available configurators, now.

These are displayed with the following columns:

• Name: This displaysthe name of the configurator.
• Templates: This displays the count of product listings created using this configurator. Clicking on it displays all ofthe products listed.
• Site: This displays selected site name for this configurator.
• Category: This displaysthe selected listing category for individual products listed through the configurator. From here we can also change this category.
• Specification: This button shows the number of specifics used by this configurator for listings. This is for single product listings. • Variations: This button display the count of variation listings added to the channel using this configurator. This is used for variation product listings only.
• Show: This checkbox lets you decide of this configurator will display in the listing screen or not.
If the checkbox is not ticked, the configurator will not be displayed on the product listing page.

To add a new configuration, click on the Add New button.

2.1.3 Clicking on the Add New button opens a screen:

Name: Enter/edit the Configurator name.
Site: This dropdown field contains the OpenCartchannel account name or names (SubSource) from your Linnworks account.

After completing and checking the fields click on the Save button.

2.1.4 For a single product listing, a newly created Configurator is added to the main screen, as below.

It’s not compulsory to add a specification for a single product listing, but allows you to replicate the feat for other products much more easily moving forwards.

We start by adding a category to the newly created configurator. You can in fact select and add multiple categories, by clicking the gear button, shown below.

Tick the boxes for the categories you want this configurator to list products in. Select Save when finished.

After creating a configurator, you should move to the listing inventory screen.

The top of the Inventory display gives you the following options:

• Select site: This dropdown field contains all the integrated OpenCart accounts (Sub Sources) from your Linnworks account. You can select one of them. When you select a site, a product list is displayed with data for site selected.

• Search: Using this option, you can filter your displayed products by Category, SKU, Title and barcode.

The display on the main screen is affected and used as follows:

• Before the SKU column, if you see a blank value, it means this product has no variation children. If you see a symbol, this means the product is a Variation product, with children. By clicking on the symbol you can see the children as a list.
• SKU: This field displays the product’s unique identifier.
• Title: This field displays the product’s title.
• Barcode: This field displays the product’s barcode (UPC/EAN).
• Retail Price: This field displays retail price you have set for the product.
• Level: This field displays the physical stock level for the product in Linnworks.
• In Open Orders: This field displays a count of the number of this product sold from the contents of the Linnworks Open Orders screen. Only linked/mapped products are counted.
• Available: This field displays the stock available to sell in the Linnworks inventory (Shelf stock level less the items in Open Orders and paid for.
• Create Listing: This shows if the product has already been listed.

This symbol indicates that this product has not been created/listed on the OpenCart channel. You can therefore list it using the Listing Tool.

On left clicking this field, you are offered three options:

1. Edit Listing
2. Create Single Listing
3. Create Variation Listing
If it is a single product, then you can select the Create Single Listing option only. The other option(s) will be disabled. Clicking on the Create Single Listing option displays another list, containing the available configurators.
You can select one by clicking on it. You will then proceed to the single item listing page.

If it is a variation product, then you can select the Create Variation Listing option only. The other option(s) will be disabled. Clicking on the Create Variation Listing option displays another list, containing the available configurators. You can select one by clicking on it. You will then proceed to the variation listing page.

This symbol (or similar) indicates that this product is already listed on the OpenCart channel. You can use the Edit Listing option only. You cannot list if an item has already been listed.

<2.1>Single Listing:

2.1.5 Clicking on the Create single listing option is only possible for visible SKUs, and they must have anExtended Property as below:

Name: Subsource (In this example oc_ind02)
Value: true

To list a SKU/Item on a OpenCartstore, you must bear in mind the following points:

The compulsory fields to create a listing on OpenCart are:

1.1 SKU
1.2 Title
1.3 Description
1.4 Retail Price (Price cannot be 0 or negative)
1.5 Tags
1.6 Configurator
1.7 Image

SKU:Your Linnworks SKU will be used as the OpenCartListing SKU.

Title:Initially, the Linnworks item title will be displayed in the Title Text box. You can make changes in this title according to your needs for the listing on OpenCart. Once the listing is completed here, the same Title will be recorded to use for future changes unless you edit it again.

Note for Title: Use the following template to build your product names: Main brand + Sub-brand, family or product name + Up to 3 key attributes + Generic product type. Product Names must be clear and concise and should also be descriptive of the product being sold. This template will help consumers identifying your product.

Description: To add/editthe listing description, please click the button in that column. Click Save when finished.

Fill the detail of description and click save button to save detail.

The first time you list a product, the Description will be empty. Once the Description is entered and saved on this screen, and the listing is completed, the same description will be shown on re-entering this screen. After Saving, the description button will change from Empty to Filled.

Retail Price:

By Default, the Linnworks Retail Price will be displayed on this screen.

Tags:

Please Note: Tags are Non-hierarchical keywords or terms assigned to each product in your feed. This metadata helps describe an item, and allows it to be categorised and found again by browsing or searching on OpenCart.com.

Tags should be comma separated, but do NOT use commas within individual tags. The more tags you add, and the more accurate your tags, the better the chances our users will find your products. There is a maximum of 10 tags allowed per product, more than 10 means that the extra tags will be ignored.

A popup screen with a text box for adding tags will be opened. User can add maximum 10 tags with comma separated values.

Once all tags are added, click on theSave button. This will save all of the tags in the item’s Extended Properties. After saving, the button label will be changed from Empty to Filled.

Configurator:

The configurator name cannot be changed. It was set earlier in the process.

Create Listing:

If the listing status column is Yellow, with the text “Not Listed”, then you have not listed the item.

Once the title, price, description and tags have been added/updated, please click on the “Create” button. This will send the listing for creation on OpenCart.

If the listing is successfully created on OpenCart,the status will be changed to“Listed”,and the colour will change to Green. The button label will also be changed to “Update” and the check box is ticked, to show that this product is enabled on the channel.

Once theproduct is created, the URL column enables, so that you can access the listing from this screen. Clicking on the chain button in this field opens the OpenCart site with the product listing.

The Configurator screen is now updated, as shown below. Now that the configurator has been used to list an item, the count is updated to reflect this change.

Clicking on the Template value opens a new window with the following details:

• SKU: Product SKU used when creating the listing on OpenCart using this configurator.
• Name: Product title.
• Listed On: This field displays the date onwhich the product was created.

<2.2>Variation Listing:

For Variation item listing, as with single items listings, the user needs to add the following Extended Property to the Variation parent.

Name: Subsource (In this example OpenCart_31082017)

Value: true

Only variation parents with this Extended Property containing the correct Sub Source will be displayed for listing.

You should also add an extra Extended Property for the price, this has the same name, but with ‘_price’ at the end, and contains the price you wish to charge.

2.1.1 Before starting a Variation product listing, we need to ensure there is a Variation-ready Configurator for it. We use the same Configurator screen as we do for single product listings.

The main difference here is that we need to add variations into the configurator.

After clicking on the Variations field, a window will pop up containing the following details:

• Name: This dropdown contains all the options available for variation options on OpenCart.
• Extended Property: This dropdown contains the list of available Extended Properties from Linnworks.
• Default Value: You can add a value here that will be used if the parent/child being listed doesn’t have the correct Extended Property for the Variation.

Click on the save button, and the configurator screen will be updated with the count of 1 instead of 0.

Using the configurator Variation, we can now almost perform a Variation Listing. We only have to do one more thing.

We have to ensure the specified Extended Property is added to all of the child products for this variation in Linnworks.

egEBG1001 is a parent product, and has four child products. We therefore have to add the Extended Property Colour to all four children in Linnworks with different colours. If you specify more than one Variation field, you CAN have repeats, but only if no 2 products in the variation group have the same combination of the 2 values.

We can now start variation product listing.

1. For variation listings:

The following are compulsory fields to list on OpenCart with this tool:

1.1 SKU
1.2 Title
1.3 Description
1.4 Tags
1.5 Configurator
1.6 Variation
1.7 Image
1.8 Price

SKU, Title, Description, Tags and Images are added as described for single listings.

SKU:Your Linnworks SKU will be used as the OpenCartListing SKU.

Title: Initially, the Linnworks item title will be displayed in the Title Text box. You can make changes in this title according to your needs for the listing on OpenCart. Once the listing is completed here, the same Title will be recorded to use for future changes unless you edit it again.

Note: Please bear in mind the following template to build your product names:
Main brand + Sub-brand, family or product name + Up to 3 key attributes + Generic product type.

Product Names must be clear and concise, and should also be descriptive of the product being sold. This template will help consumers identifying your product.

Description: For adding / editing the listing description, please click on the button in that column. Click Save when finished.

The first time you list a product, the Description will be empty. Once the Description is entered and saved on this screen, and the listing is completed, the same description will be shown on re-entering this screen. After Saving, the description button will change from Empty to Filled.

Retail Price:

By Default, the Linnworks Retail Price will be displayed on this screen.

Tags:

Please Note: Tags are Non-hierarchical keywords or terms assigned to each product in your feed. This metadata helps describe an item, and allows it to be categorised and found again by browsing or searching on OpenCart.com.

Tags should be comma separated, but do NOT use commas within individual tags. The more tags you add, and the more accurate your tags, the better the chances our users will find your products. There is a maximum of 10 tags allowed per product, more than 10 means that the extra tags will be ignored.

A popup screen with a text box for adding tags will be opened. The user can add a maximum of 10 tags with comma separated values.

Once all tags are added, click on theSave button. This will save all of the tags in the item’s Extended Properties. After saving, the button label will be changed from Empty to Filled.

Variations:

By clicking on the Variation button, you will see a list of the Child products for the variation, with the below details.

• SKU: Child product SKU.
• Title: Child product Title.
• Specific Name: If the Colour is specified in the configurator, for example, that will be the title. The child product’s Extended Property value is then display here.
• Quantity: This displays the stock level of the child product in Linnworks’ inventory.
• Price: This field displays the price of the child product. A +control displays thevalueof the parent product plus this price. This value is set in an Extended Property. If no Extended Property is specified for the Child, then just the default value is shown by the +.

Once all details are entered, please click on the “Create” button to create the listing.

As with single listings, once the listing is created the status will changed to “Listed”, and the button label will become“Update”. Thecheckbox being checked means this product is visible on the channel.

Once the listing is created, the URL column button is enabled. Clicking it opens the OpenCart page, and displays the listing you created.

<2.3> Edit Listing:

If you want to update the title, price, description, category, imagesor tags on OpenCartfor a listing you have already created, there is the Edit Listing option in the main inventory screen. Regardless of whether it is a single or variation listing, you’ll be directed to the correct options. You can then apply the new details to that product by clicking on the Update button.

The last column contains a checkbox that controls the status of the listing on OpenCart. If checked, the product is active and visible to customers. If unchecked, it isn’t visible and can’t be purchased, regardless of the available stock level.

This document can be accessed by clicking on the Documentation button, and opens a new tab:

Get your free quote

Call 0208 090 4547

Hear From Our Clients

Best website/e-commerce vendor I've worked with in my 10 years of being an IT PM! We hired eBusiness Guru to create our e-commerce website for our premium brand. This was no easy task as it was not your traditional e-commerce site. They delivered on-time, on-budget, and all with a successful release to the public and established partnership with us. We enjoyed working with the whole team. I would highly recommend them for any website need.
Bastien Peyronnel

Certifications