Video
Overview
24sevenCommerce - POS and eCommerce Integration
+1 408-643-0097
Live Chat

Zedonk Opencart Integration Manual

Request a Demo

Octopus Bridge Intro

Octopus Bridge is an application that enables brick & mortar retailers to connect their ERP system with their e-commerce website and online marketplaces.

The flowchart below shows Octopus Bridge linking Zedonk data to online stores and marketplaces. It also shows the item information uploaded from ERP to E-commerce and order quantity pushed back to Zedonk from the e-commerce platform so that the stock can be in Sync.

Octopus-Channel-Intro.jpg

After you sign-up with Octopus Bridge, you will be given the login details. Login details are your username and Password. You can login to your account at http://gui.octopusbridge.com/octopus

Loginocotpus

Once you login to Octopus Bridge using your login details, you are automatically redirected to the Product Management tab where you will be able to see all the items uploaded from the ERP.

My Products

When ERP items are uploaded into Octopus Bridge, they show up under ‘My Products’ tab in the Product Management module. This is where a user can further modify the products before they are pushed to an E-commerce platform.

The topmost item or the first item displayed on this page is the last item uploaded from the ERP. Example shown below: The item with Product SKU number ‘7909510673809’ is the last item uploaded from the ERP.

Zedonk products

In the product management module, a user can perform the following actions:

1. Advance Search: To view advance search, click on the + button on top right corner of the screen.

2. Push Products to Shopping Cart: To push products to the shopping cart.

3. Select All Pages:This will Select all the products listed under the Product Management module

4. Items Per Page: This will allow selecting the no. of items you want to display per page.

5. Select All Items on the Current Page: Clicking on this checkbox will allow you to select all products on the current page.

6. Edit Product: Click on Product SKU or Product Title to edit product information.

7. Delete Product: To delete a product, click on the checkbox in front of that particular product and click on the “Delete” icon located on the right side of the screen.

products search

8. Archive Product: To archive a product, click on the product(s), you want to archive and click on the delete button below.

9. Select Item(s): To select one or multiple items, click on the checkbox in front of it.

Select items


Advance Search

Advance search

You can search for a specific item with the following search criteria:

  • Source Category
  • Item SKU
  • Item Description
  • Item Keyword
  • Parent SKU
  • Brand
  • Marketplace
  • Item Status
  • Location
  • Style
  • In stock?
  • Supplier
  • Date Added
  • Price Range
  • Stock Level
  • Image Status
  • Custom Fields
  • Store

If Product items are not shown after doing a search, it means that the product item is not yet synced from the ERP. Also, make sure that in searching items, you are using the correct Item SKU or Parent SKU. Example below shows that the item is not yet found in Octopus Bridge.

search item by item skus

Edit Product

Clicking on Product SKU or Item Name will redirect you to the ‘Edit product’ page. This is where you can edit products’ information that are linked from the ERP to Octopus Bridge. You can perform the following actions in Edit Product page:

1. Edit Product Name: You can create new product name to be displayed in your E-commerce platform. Make sure to click on the box to prevent over-writing Product Name from the ERP.
2. Create Parent SKU: Make sure to create a Parent SKU for creating matrix items.
3. Create Product Description: If you want to create a new description to be displayed in your E-commerce platform, make sure to check this box to prevent ERP description from over-writing description in your E-commerce platform.
4. Matrix item attributes: If you are creating a matrix item, make sure to input Style Name and Style Value.
5. Upload Product Images: You can upload up to five images per item in Octopus. Make sure to reload page after uploading image/s.

edit products

Import Products

If you do have a point-of-sale system or want to quickly edit items by Exporting / Importing multiple items, Import Products is a great option.
1. Click Add New Template to start.
2. Click History to select a file previously uploaded on Octopus Bridge.
3. Click Import New to import a new template after it has been created.

4. Actions:

  • Notify– you can type in your email to get notifications if modifications are being made in the file.
  • Modify– click to update files.
  • Delete– delete existing files from the list.

Import Products

Add New Template

You can view the past import activities in the channel by clicking on Import History.

1. File Type: Select the File Type from the dropdown.
2. File Name: Type in the name of the file you wish to create.
3. Column Delimiter and Text Qualifier: Use only if file type is a text file.
4. Save file after choosing the file type and the file name.

Add Product Templets

POS Code Mapping

You can use POS code mapping if you want to map ERP values to octopus bridge values. ERP values are commonly in a coded format. For example,blk. You need to set blk into black which is more understandable for users viewing the website. You can also map multiple values at the same time using a spreadsheet format.

1. POS Code Upload Format: You can download the excel format by clicking on the “POS Code Upload Format” link.

2. Choose File: Once you have made changes in the excel format, select spreadsheet file to upload.

Click on upload after selecting file.

Select Field Name.

3. Replace All Value: Click to replace value after selecting Field Name.

4. Item per Page: Clicking this will create a drop-down box where you can select how many product items to be displayed per page.

5. Search: You can search specific value using the search bar.

6. Channel Value: Edit Channel value here.

POS Code Mapping

Publish Items to Shopping Cart/Marketplace

After you update item information under ‘Edit Item’ page, you can go ahead and publish this item/s to a specific Shopping cart or Marketplace. Please follow the steps below to publish.

1. First you need to select which item/s you want to publish. In the example below shows we are selecting three items.

2. Next, select which Shopping cart or Marketplace you want to publish the item. In the example below we are selecting Shopify as our shopping cart.

3. Then click on the Add icon on the right to publish. Once you are done, items can now be viewed under the Shopify ‘bucket’

Publish Items

Note: Only Shopping carts and Marketplaces that you signed up for, will be shown in My Products page.

Shopping Cart Module

Once you have selected and added your product items to a specific Shopping cart module or Marketplace module ‘bucket’, they will start appearing under the respective bucket. Images are shown below.

Marketplace Tab:-

marketplace tab

Shopping Carts tab:-

Shopping cart tabs

 

Logs

You will be able to view all the Octopus Bridge activities and errors in the ‘Logs’ tab.

  1. You can search logs on a specific date period or search using a keyword in the search tab at the top.
  2. You can export logs to a CSV in your local drive.
  3. You can view Log details by clicking on the ‘view’ button on the right-hand side of the screen.

Logs

Log Details is where you can view the log activities or the error details in the channel.

logs details

About Zedonk

Zedonk is a web-based ERP software designed specifically for the fashion industry to keep up with the ever-changing needs of the industry. It has evolved to match the demands of the industry ensuring people can run their business smoothly and stress-free and is accessible for brands/businesses of all sizes. It allows merchants to access and securely store all their real-time data from anywhere in the world. No need to download or install, just go online and login to get up and running.

Zedonk integration enables Fashion, Accessories, Shoes, Jewellery, and Homeware brands to sell on multiple popular eCommerce shopping carts and marketplaces including Shopify, WooCommerce, BigCommerce, Magento 1.X, Magento 2.X, NopCommerce, Amazon, Farfetch, eBay, Google Shopping, etc.

Zedonk Setting Details

1. Login to your Octopus account and go to POS/Zedonk/Settings.

2. You need to enter the Zedonk API details provided by Zedonk, in the Settings tab to connect Zedonk ERP to Octopus.

3. If you want to automatically update items from Zedonk to your Octopus, select the Sync status to “Enable”.

zedonk setting details

Zedonk Custom Rules

This is where we can set different settings for the products. These settings include

• Schedule Setting panel
• Lockdown Setting Panel

Schedule Setting Panel

zedonk schedule setting panel

•  Schedule Time: Scheduler time is set for automatic product data upload from ERP into Octopus.
•  Sync All Inventory: Check this box, if you want to sync all products from the ERP to Octopus.
•  Website Brand: This dropdown allows you to select one of the Zedonk fields and save it as a Brand. This is useful if you want to use Brand in your website.
•  Price: Select any of the ERP prices from the dropdown to assign it as a regular retail price for the website.
•  Price A/B/C: If you intend to use different prices for different website platforms, Price Levels A, B, and C are a great way to keep them separate.
•  Cost: You can select what you want to save in Cost, from the dropdown menu.

Field Lock Setting Panel:-

You can click on the box to select if you don’t want to update any data from Zedonk to Octopus.

Zedonk Field Lock Setting

Seasons

Before items can be pulled from Zedonk, we need to Sync up all the seasons. To sync Seasons, click on the Sync Seasons button and all the Seasons will be synced. If you want to import product data from a specific Season, please select the Season and Save. During the next Sync cycle, products will be imported into Octopus.

Zedonk Seasons

Sync

After all the settings are done for Zedonk ERP, click on Start Synchronization. This will start downloading the inventory from Zedonk to Octopus. Please note, depending upon how many items are there, it may take few minutes to few hours.

Zedonk Sync

 

Buying Opencart API extension

To connect octopus to Opencart, the opencart version should be 3.0 and above. The customer has to purchase the Opencart REST Admin API:

https://opencart-api.com/product/rest-admin-api/

While purchasing the API extension:

  1. From Opencart version dropdown, select opencart 3.x
  2. From API security dropdown, select Simple(Secret Key)

Installing the extension

1. After you buy the extension, you will receive an email with ZIP folder and order ID. Unzip the folder and upload this extension with the help of FTP. Once the installation is complete, go to Extensions from the left menu and select Modifications.

Installing the extension

2. Click on the Refresh button on the top.

Generating Opencart API Key

AnOpencart Key is necessary to connect your Opencart store to Octopus. Please follow the steps below to create an API key.

1. Login to your Opencart Admin portal.

2. Click on Extensions from the left menu and select Extensions from the expanded menu.

Screenshot 4

3. From the Extension Type dropdown menu, select Modules.

Screenshot 5

4. In modules, go to Rest Admin API and click on the edit button.

Screenshot 6

5. Enter the Order ID received on the email in Your Order ID field and click on Activate License Click on the Generate API Secret key button.

Screenshot 7

6. Your Opencart API Secret Key will be generated.

Connect Octopus to Opencart

1. Go to https://gui.octopusbridge.com/octopus

2. Login using user octopus account credentials.

3. Once you have logged in, go to shopping carts/Opencart.

Screenshot 8

5. Click on settings and enter the following information

Screenshot 9

  • Opencart Key: Enter your Opencart Secret API Key.
  • Opencart Secret Key: Enter your Opencart Secret API key.
  • Opencart Base URL: Enter your Opencart store URL.
  • Enable Pass-through: When setting up the configuration for the first time, this option should be set to No.
  • Setting No, means that any items uploaded from the POS to Octopus will remain at Channel level. These items will not be pushed to your Opencart platform unless it is done manually. This is the recommended setting while configuring the system for the first time.
  • You also may set this to No if you have set up your POS to upload All items into Octopus, but you do not want to send All items, automatically, to your eCommerce platform. Setting this to No gives you the opportunity to make items web ready before publishing them to your website.
  • Once you set it to Yes, any items uploaded from the POS will automatically be pushed to your Opencart platform. This is recommended only when the settings have been fully configured and tested.
  • Sync Status: Select Enable

Opencart Product Module

In Product Management, when an Item is selected to be published to an eCommerce platform, it is first sent to the specific Shopping Cart Module (SCM). SCM for each supported shopping cart, including marketplaces such as Amazon and eBay, gives users the ability to define shopping cart specific rules.

These rules may vary based on the eCommerce platform that you are using. For example, Items being sent to Opencart may have a different Product Name, Prices, and Quantity as compared to items being sent to eBay.

Whereas ‘Product Management’ module shows all the products uploaded from the POS, Opencart Product module shows only those items that are actively synchronizing with Opencart.

  1. Hover your mouse to the Shopping Carts tab
  2. Select Opencart under the dropdown menu
  3. Click on Opencart products

Screenshot 10

All Opencart Products

  1. This screen shows items that have been enabled to sync with Opencart and should already be in sync. To manually publish items to Opencart, Select All Pages and Publish.
  2. You can also use CheckBoxes to select a specific item to publish.
  3. Product SKU: The dot is an indicator if a product is successfully synchronizing with the website. Green means successfully added while red means it is not successfully synced. If Red, you can use the Log files to troubleshoot.
  4. Opencart ID:When an item has been successfully set up to sync with Opencart, it shows its Opencart ID. If an ID is missing, it means the item is not yet synced with Opencart.
  5. Add Product to Opencart: This button allows you to add products to an Opencart website.
  6. Search tab: This tab allows you to search for a specific item by entering the product SKU or keyword.
  7. Item per Page: Clicking this will create a drop-down box where you can select how many product items to be displayed per page.

Screenshot 11

Download Brands

If you intend to use Brands on your website, you need to create them in Opencart and download them into Octopus. Click on the Download Brands button to start downloading. Once Brands are downloaded in Octopus, they will show in Map Brands section.

screenshot 15

Map Brands

This option allows to ‘map’ POS Brand structure to Opencart Brands so that POS brand labels are placed in the right item when loaded into Opencart platform.

  1. The left-hand side shows the POS Brand structure.
  2. Downloaded website brands from Opencart platform are shown on the right-hand side with a drop-down box.
  3. The drop-down menu shows mapped and unmapped brands. To map additional brands, click unmapped Brands from the drop-down menu, then select which brand to map.

Screenshot 16

Download Categories

In order to make sure products are displayed in the correct product category in Opencart, make sure to create your Department & Category structure in Opencart first. Once created, you can Download Category structure into the Channel.

To download Opencart Category:

  1. First you need to click on the Download Category tab
  2. Then click on the ‘Download’ button

Once you download categories it will show how many categories that are downloaded successfully.

Note: Always download categories to update Octopus every time you create/update a new category in Opencart.

Screenshot 17

Map Categories

When items are uploaded from a POS into Octopus, they are uploaded with POS Department & Category structure. At the Octopus level, it’s called Source Categories.

POS Category structure may or may not be the same as Opencart Category structure. This option allows to ‘map’ POS category structure with Opencartcategories so that POS items are placed in the right category.

  1. The left-hand side shows the POS category structure.
  2. Department & Categories downloaded from Opencart are shown on the right-hand side with a drop-down box.
  3. The drop-down menu shows mapped and unmapped categories. To map additional categories, click unmapped categories from the drop-down menu, then select which category to map.

Screenshot 18

Map Product Attributes

Merchants using various POS systems may use any of the fields within a POS while creating items.

  1. Map Fields option allows a merchant to map Opencart product fields with their own POS product fields.
  2. For example, Opencart website Product Name (Title) can be mapped with any of the POS data fields provided in the pull-down menu.
  3. This also provides an option DO NOT UPDATE to not send certain POS data to Opencart website.
  4. Some fields, such as, SKU and Quantity are mandatory and are automatically updated in the website.
  5. The left-hand side shows the Opencart fields. The right-hand side shows the POS fields

Screenshot 12

Custom Rules

In the Custom Rules tab, product-specific rules should be defined before the items are set up to sync with Opencart. Once done, all items synchronizing with Opencart will inherit these rules.rule(s) set here will be applied to all the products being uploaded from Channel to Opencart.

Custom Title: This feature allows you to create a search engine friendly Product Name by combining multiple fields. For example, you may want to use Product Name and Brand fields from POS to create a unique eCommerce product name, resulting in ‘Product Name by Brand’.

custom title

  1. Click on Add Fields.
  2. Select a field, such as Product Name
  3. Enter Separator, such as, By
  4. Click on Add
  5. Once again, click on Add Fields
  6. Select another field, for example, Brand
  7. Remember to remove the ‘Enter Separator’ from before
  8. Click on Add

product name

Going forward, before an item is sent to Opencart, this rule will combine the fields to create a unique name. If left blank, Custom Tile does not apply.

Set Deduction Rule:The quantity inserted in this box is reduced from the Product Management stock. For example, if a Product Management item quantity is 50 and you insert 10 in the ‘Enter Value’ field; in Opencart, the quantity of the item will be shown as 40.

Screenshot 13

Set Quantity Rule: Regardless of the stock level in product management, as long as the quantity in opencart is greater than the quantity entered in the enter value field, the product will remain in stock in opencart. As soon as the quantity becomes equal to the quantity entered in the box, the product will become “Out of Stock” on Opencart.

Screenshot 14