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

ERPLY Walmart Integration Manual

Request a Demo

About Octopus Bridge

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

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


Octopus-online-integration
 

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

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 POS.

Product Management

When POS 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 top most item or the first item displayed in this page is the last item uploaded from the POS. Example shown below: The item with Product SKU number “7909510673809” is the last item uploaded from the POS.


My Products - Octopus





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.  

My Product 2




Edit Product

Clicking on Product SKU or Item Name will redirect you to ‘Edit product’ page. This is where you can edit products’ information that are linked from the POS 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 POS.
  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 POS 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.

Octopus-edit-products

Publish Items to Shopping Cart/Marketplace

After you have updated an item under ‘Edit Item’ page, you can go ahead and publish this item to a specific Shopping cart or Marketplace. Under Product Management tab.

1. First you need to select which item/s you want to publish. 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.

Publishing-Items-to-eCommerce-Octopus

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

Marketplaces

Shopping Carts tab

Shopping cart

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. Action:
  • 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.
All-Import-Templates-Octopus

Add New Template:

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

1. File Type: Clicking this will create a drop-down box where you can select the File Type.

2. File Name: Type in the name of the file you wish to create.

3. Column Delimeter 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-New-Templets-Octopus

POS Code Mapping

You can use POS code mapping if you want to map POS values to octopus bridge values. POS 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.
  3. Click on upload after selecting file.
  4. Select Field Name.
  5. Replace All Value: Click to replace value after selecting Field Name.
  6. Item per Page: Clicking this will create a drop-down box where you can select how many product items to be displayed per page.
  7. Search: You can search specific value using the search bar.
  8. Channel Value: Edit Channel value here.

POS-Code-Mapping

Order Management

Order management tab is where you can view all the order details downloaded from your E-commerce platform. Click on View Orders and you will be redirected to the order management page.


Order-Management-Octopus

Order Search

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

  • Source of Order: You can select the shopping cart/marketplace from where the order was placed
  • Order Status: Ordered/Shipped/Declined
  • Order No: Specific order number of shopping cart/marketplace
  • Username/email address: Customer’s username or email address
  • Date Filters: Sort order on a specific date period
  • SKU: Item SKU Number

order 2

All Orders:

Order Date: The date and time when the order was downloaded

Channel Mgr Order #: Each order, when downloaded into Octopus, is given an Octopus order number. This number is also pushed to the point of sale system for reference.

Marketplace Order #: This is the order number received from your website or marketplace. The number is prefixed by the platform abbreviation for easy reference. This number is also downloaded into the point of sale system.

Customer Bill To and Customer Ship-To Details are received from the website.

Total: The total amount of the order.

Status: Depending on where the order is coming from, it would be either in Pending/Processing or Paid status. Orders coming from marketplaces are marked Paid as they are already paid for. Orders coming from websites built on Magneto/Woo/etc might be marked as Processing depending on how the website is set up.

Tracking: This feature is only applicable for Offline POSs, such as RetailPro, RMS etc. Octopus Plugin updates the Tracking Number on our system generated by the Shipping company of the Merchant. It also works for the merchants, who uses Ship Station and Ship Work integration with Octopus.

Action: When orders are downloaded from website into Octopus, all items must match with items uploaded from the POS. For example, if an ordered item has a different SKU than what was uploaded from POS, the order will NOT be downloaded. In such cases, Edit link will show. This allows you to Edit the order and fix the SKU number so that it matches with one of the existing items. After the SKU has been fixed, the order would download during the next sync cycle. Orders not showing Edit indicates that the orders have been downloaded into POS and cannot be edited.

Page Tab: You can navigate to a particular page by clicking on that particular page number.

order management

Downloading Orders

Orders are downloaded automatically from the E-commerce platform to Octopus on a scheduled basis. You can also manually download orders from a specific E-commerce platform. Just click on the orders tab in the Shopping cart module you selected then click on the ‘Download orders from Shopify’ button.

download orders

Order Details

In order details page, you can view all the order information downloaded from the e-commerce platform to Octopus.

Order Details: Order details section contains the following information:

  • Order No
  • Order Date
  • Current Order Status
  • Billing Address
  • Shipping Address
  • Customer Contact Details

Order Summary: Order summary section contains the following information:

  • SKU
  • Identification number
  • Seller SKU
  • Description
  • Quantity
  • Unit Price
  • Shipping Amount
  • Tax
  • Discount
  • Grand Total

Order details

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.


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

Logs Details

About Erply Integration

Erply is a web-based POS system that makes it accessible from anywhere and contains features for every aspect of your retail business. Erply POS allows you to take an open approach to a multi-channel retail platform. Erply is utilized to drive business, regardless of where the transaction takes place, in-store, on mobile or on the web. It brings a seamless environment that can truly benefit both your business establishment and your customers.

Erply’s POS helps your company save money, efficiently execute transactions, and make more informed business decisions. We have a very intuitive POS interface that’s accessible on desktops, laptops, iPads, Android devices, mobile phones, Windows and iOS operating systems – and of course, through point of sale devices.

Our solution brings the power and functionality of a traditional POS system to a handheld device, giving your business a professional feel without the professional cost. All POS transaction data entered into the app will automatically be synchronized in real time with your Erply account, leaving all of your books and reports completely accurate 100% of the time.

Erply Setting Details

The Setting tabs is where you enter Erply API details to connect Octopus to Erply.

We suggest you to create a new ‘Web’ user account in Erply with Read and Write permissions.

After creating Erply account, please log into Octopus and go to POS > Erply > Settings and add the user login details. Sync Status should be selected as Enable to automatically pull Erply data into Octopus. Press the Save button. Octopus now should be connected to your Erply POS.

ERPLY-Setting-Details

Note : You can select the Sync Status as Disable while you’re still setting it up. Please remember to go back and select Enable when ready.

Erply Custom Rules

This is where we setup custom rules that help setup integration between Erply and Octopus. These settings include scheduling, style mappings, inventory management, mappings of pricing/sizes, etc.

Schedule Setting Panel

 

1. Scheduler Time: This setting allows you to automatically update/upload product data from Erply to Octopus. Scheduler time is set by time intervals.
2. Next Time Synch: This shows the time when next synch cycle will run
3. Last Synch Cycle: Shows when the last synch cycle ran
4. Sync All Inventory: Check this box if you want to sync all products from the POS.
5. Pull Inventory From: Select which Inventory you want to pull from Erply
6. Stock Level: Select between Total Stock, Reserved Stock or Free Stock in Erply

Schedule-Setting-Panel-ERPLY

7. Size Attribute Name: Color, Size, etc.
8. Parent SKU from ID: Select ID or Code, from where you want to Import the SKUs.
9. Save Order As: When an order is downloaded into Erply, how should it be saved.
10. Save Brand As: Select Brand or Supplier name.
11. Currency: Select type of currency used in Erply
12. Price: Select Price, Price with Vat, Cost, Price List price, Price list with Vat depending on the price you want to display in your E-Commerce platform.

ERPLY-Rules-7-to-12

13-15. Price Levels (Price A, Price B and List Price): Select which price to map with different price levels.
16. Order Employee ID: Select the Employee ID
17. Register ID:

ERPLY-POS-Rules

Field Lock Setting Panel

After the initial product pull from Erply, you can define which attributes of an item should NOT be overwritten in Octopus. This feature is useful if you are using Octopus to manage your items. Please see the image below:

Field-Lock-Setting-Panel-ERPLY

Erply POS Panel

To access the Erply POS panel, first, you need to hover your mouse to POS in the main menu > then click Erply

After all the settings are done for Erply POS, “Click on Start Synchronization”

This will start downloading the inventory from Erply to Octopus, as per the settings done.

Erply-Synchronization

Generating Walmart API Keys

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

  1. Go to Walmart Developer Portal ( https://developer.walmart.com/ ) and click on My Account.

walmart-9

  1. Select login type marketplace based on your location.

walmart-10

  1. Login to Walmart developer portal using your login credentials.

 

Walmart-11

  1. From the left menu, click on API keys.
  2. In the My API Key section, your client ID and client secret are displayed.

Walmart-Keys

Connect Octopus to Walmart

 

  1. Click on settings.

Walmart-2

  1. In the Marketplace Name field, enter your marketplace URL.
  2. In the Client ID field, enter the Walmart Client ID
  3. In the Client Secret field, enter the Walmart Client Secret key.
  4. In the correlation ID field, enter the correlation ID. This is a random alphanumeric number with
  5. 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 Walmart 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 Walmart platform. This is recommended only when the settings have been fully configured and tested.
  1. Sync Status: Select Enable

Walmart Products

In Product Management, when an Item is selected to be published to a Marketplace platform, it is first sent to the specific Marketplace. SCM for each supported shopping cart, including marketplaces such as Walmart, 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 Walmart 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, Walmart Product module shows only those items that are actively synchronizing with Walmart.

  1. Hover your mouse to the Marketplace tab
  2. Select Walmart under the dropdown menu
  3. Click on Walmart products.

Walmart-New

  1. This screen shows items that have been enabled to sync with Walmart and should already be in sync. To manually publish items to Walmart, Select All Pages and Publish.
  2. You can also use Check Boxes 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. Add Product to Walmart: This button allows you to add products to an Walmart website.
  5. Search tab: This tab allows you to search for a specific item by entering the product SKU or keyword.
  6. Item per Page: Clicking this will create a drop-down box where you can select how many product items to be displayed per page.

Map Item Code

  1. In order to upload items to Walmart, you need to map the Walmart Seller SKU with Product SKU in octopus. In order to do this you can:
  • Download Sample File: You can download sample SKU Feed format and add items to upload to Channel. Add product SKU of an item in the first column and its Walmart Seller SKU in the second column.
  • Import Seller SKU: You can download spreadsheet with existing products in Walmart bucket. You can make some changes from spreadsheet and re-upload product items. Add product SKU of an item in the first column and its Walmart Seller SKU in the second column.
  1. Choose file: Select a file to upload. Make sure spreadsheet file follows the Sample Identifications format.
  2. Upload file: Upload file after choosing a spreadsheet file.

walmart-3

Map 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 Walmart Price field with their own POS Price fields.
  2. The left-hand side shows the Walmart Price field whereas the right-hand side shows the POS fields.

Walmart-4

Custom Rules

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

  1. Safety Net 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 Walmart, the quantity of the item will be shown as 40.

Walmart-User-Manual

  1. Currency: Enter you currency here
  2. Seller SKU: Check this box if Walmart Seller SKU is different from Octopus SKU.
  3. Order Inclusive Tax: Select this if you are posting products including tax.
  4. Enable WFS Orders: When this rule is checked, the orders fulfilled by Walmart will start downloading to octopus.
  5. Fulfillment Lag Time: Fulfillment lag time is the time a merchant would take to fulfill a received order. The time should be entered in days (0 or 1).