In this article
After going through the configuration in Shopify, you can add a store to the LS Central Shopify Administration page. You can map multiple Shopify stores to different Central stores, just add a new line. Each store can have its own Key and URL and mappings.
The table below lists available fields on the page:
| Connection | |
|---|---|
| Store Code | The LS Central store to assign as Shopify store. |
| Shopify API Url | Consists of the Shopify store name and the Webhook version. |
| Shopify API Key | A key created in the Shopify API Credentials page. |
| Shopify Location ID | The ID of the Shopify location that will handle inventory status. This ID can be found in the URL when looking at the Shopify Location setup. |
| Settings | |
| Line Discount Code | Default Line Discount Offer to register a Shopify discount when a Shopify order includes discounts. |
| Product Type Field | Item field to use as Product Type for Shopify Product. |
| Deny out-of-stock shopping | If you select this check box, Shopify cannot sell items that are out of stock. |
| Use POS for Local Delivery | Use POS to handle local delivery orders. Orders will be created as Click and Collect orders and show up on POS. If not selected, Sales Orders will be created. |
| Order creates contact | Creates a member contact, if the contact is not found by email address when a Customer Order is created and assigned to the order. |
| Create Fulfilled Orders | Create Customer Order from new Shopify Order that has already been fulfilled in Shopify. If not set, fulfilled Shopify order that has not yet been created in LS Central will be ignored. |
| Include Tax in Prices | Set this value to the same as in Shopify Admin - Settings - Taxes and duties - Decide how tax is charged. If selected, all prices will be sent including tax, no matter the setting in the Retail Item card. |
| Charge Tax on variant | Set Charge Tax on variant or product on the Shopify Product card, no matter the setting in the LS Central Item card. If not selected, Price Include VAT is used. |
| Include Item HTML | Adds Item HTML data into Product description in Shopify. For valid HTML data, it needs to start with <html><body>. |
| Include Attribute in Item HTML | Adds Item attribute as a table in the Shopify product description. Used with Include Item HTML. |
| Include Vendor in Item HTML | Adds vendor and the vendor item number to the Attribute table in the Shopify product description. Used with Include Item HTML. |
| Include Extended Text | Include Extended Text lines for Items in Shopify Product description. |
| Use MetaData | Use MetaData to send down Attribute data and other Table data that have been mapped in Shopify MetaData Mapping. |
| Include Attributes in MetaData | Send all Item attributes as MetaData. If set to false, Item attributes need to be mapped in MetaData Mapping to specify which ones should be sent. Used with Use MetaData. |
| Use Variant Description | Display Variant description instead of Variant code for Shopify Options. |
| B2B Mode | B2B Mode uses Customers instead of Member Contact. Customer can only be created in LS Central and pushed to Shopify. Customer Order will use Customer No. instead of Member Contact Card. |
| Send Discount | Send LS Central Discount with price update to Shopify. Note: Only Discount Offer and Multibuy Discount are supported. Discounts can either have products or Collections. Only 200 products can be included in one discount. |
| Collections | |
| Special Groups | Create Collections in Shopify based on LS Central Special Groups. |
| Item Categories | Create Collections in Shopify based on LS Central Item Categories. |
| Product Groups | Create Collections in Shopify based on LS Central Product Groups. |
| System | |
| Product Delimiter | Delimiter used to join Item and Variant Code in Shopify SKU (Default -). |
| Missing Contact Name | Default text used for missing First / Last Name when create Member Contact from Shopify customers. If empty, a missing name field will give an error. |
| Shopify Pulling Interval | Interval to pull data from Shopify in paging mode. If set to 0 then default value in Shopify is used. |
| Delete Product | When an item is taken out of distribution, this setting deletes the product or marks it as draft in Shopify. |
| Send Contacts | Send Member Contacts to Shopify in Retail mode when running Contact Scheduler job. If not checked, only Customer are sent in B2B mode. Only Contacts / Customers with email address are sent. |
| Send Fulfillment | Send Fulfillment Web Hook call to Shopify when Order is shipped in Central |
| Send Payment | Send Payment Web Hook call to Shopify when order is finalized. |
| Last Replication | |
| Last Order Pull Last Customer Update Last Price Update |
This is the time when LS Central last pulled either order or customer data from Shopify, or sent Price updates to Shopify. Tip: If you need to move the Pulling/Pushing back or reset it, you can change the date and time value here. |
Mapping
- Click Related in the menu toolbar, and open the Mapping menu.
Note: To find the correct data that is needed for mapping, it is best to look at the Shopify Order Data when pulling an order from Shopify. To see the Order data, activate Logs in Web Service Setup, and the Request and Response Data will be logged in the Web Request log.
Tender Type
Maps payment provider in Shopify to Tender type in LS Central. The payment providers' Gateway code that is used for the mapping can be seen when you look at the debug message for Shopify Transaction.
- Map the Shopify Gateway code to the External Code 1 field, and map with the LS Central Tender type code in the Code 1 field.
In demo mode, Gateway is BOGUS.
Shipping Agent
Maps Shipping agent information from Shopify to Shipping agent in LS Central. The Shipping agent codes can be found in the debug message for Shopify Order under shipping as Source and Code.
- Map the Shopify Source to the External Code 1 field and Code to External Code 2, and map with LS Central Shipping Agent Code in the Code 1 field and Shipping Agent Service Code in the Code 2 field.
In demo mode, Source is SHOPIFY and Code is STANDARD.
Location
Maps Shopify Locations to LS Central Stores. This is used for Click and Collect orders to route orders to the correct Store in LS Central or to route Smart order routing orders to the correct Store. It is also used to include extra Inventory status for other locations than the default Web Store location. The Shopify location ID can be found at end of the browser URL when you open the location in Shopify setting.
- Map the Shopify Location Id to the External Code 1 field, and map with LS Central Store Code in the Code 1 field.
Locale
Send Translation for Items to Shopify.
Note: Item Description, HTML text, variant name, variant values, and Meta data values can be translated.
Data Translation Setup needs to be done in LS Central for Table fields, Attributes, and Variants.
Set up language in Shopify in Settings. Map Shopify locale code to the LS Central language code.
- Get Locale: Get available Shopify languages from Shopify.
- Update Locale: Used to Publish or Un-publish language in Shopify.
- Send Translation: Send translation data for selected language to Shopify.
Meta Data
Sets up Mapping of a field in LS Central tables to Shopify Meta Data entry. Fields from Item and Customer tables can be used and all fields in related tables to those (with relationship mapping to Item or Customer).
Attribute names can be mapped to different Meta Data entries names, if no mapping is done the default Attribute name will be used. If Include Attributes in MetaData is NOT selected, only those attributes that have been mapped, with default name or renamed, will be sent to Shopify as Meta Data entry.
Note: All Meta Data will be created under the lsretail namespace in Shopify.
- Meta Data Type: Type of Shopify Meta Data
- Meta Field Type: Shopify Meta Type
- Mapping Type: Rename Attribute name (DefAttribute) or use data from Field in a Table (DefField)
- DefAttribute:
- Index Field: Attribute name to rename.
- Meta Code: Shopify meta data name to use for attribute.
- DefField:
- Index Field: Table ID.
- Index Value: Field ID to get data from.
- Meta Code: Shopify meta data name to use for field data.
Sales Channel
Use Actions - Other - Get Sales Channels to fetch all Sales Channels from Shopify. Items will be assigned to all Sales Channels in the list here, so remove those that you don't want to use.
Mapping Data
- Click Related in the menu toolbar, and open the Mapping Data menu.
Products
Mapping of Shopify product and variant IDs to LS Central Item and Variant Codes. This view is only for maintenance purposes or to fix broken links. The whole mapping can be cleared for resetting the mapping between the two systems. Can be useful during testing or implementation.
Collections
Mapping of Shopify Collection IDs to LS Central Product Group / Special Group / Item Category codes.
Discounts
Mapping of Shopify Discounts to LS Central Periodic Discount codes.
Meta Data
Mapping of Shopify Meta Data to LS Central Attributes and Table fields
Actions
The Shopify Administration page has these actions:
| Action | Description |
|---|---|
| Item - Send Item | Send one Item. Note that if an item is not in distribution for the Shopify store, inventory and prices will not be updated when running Scheduler jobs. |
| Item - Delete Item | Delete one item. |
| Update - Items | Send Retail Items to Shopify products. |
| Update - Images | Send Images to Shopify. |
| Update - Inventory with Reset | Reset inventory status and send inventory data to Shopify. |
| Update - Inventory | Send inventory updated status to Shopify. |
| Update - Prices | Send Item Prices to Shopify. |
| Update - Customers | Send Central Customers to Shopify, only used in B2B mode. |
| Update - Create Collections | Create Collections based on Collection settings. |
| Pull - Orders | Pull Orders from Shopify and create Customer Orders. |
| Pull - Contacts | Pull Customers from Shopify and create Member Contacts. Only used when B2B is not checked. |
| Pull - Products | Pulls products from Shopify and maps to LS Central Item. Mapping is done by Shopify SKU = LS Central ItemNo. New Items are not created in LS Central. |
| Other- Test Connection | Test connection to Shopify. |
| Other - Clear Temp Order Data | When importing orders from Shopify, order data is stored in temporary tables during processing. If any error occurs during import, some data can be left in these tables that can cause repeated error during next import. Use this command to clear the data, before importing again. |
| Other - Get Sales Channels | Get Sales channels from Shopify to assign Products to during Product creation. |
Note: When running most of the Update and Pull commands, the same code as Scheduler code unit uses is used. Last run time or counter will not be updated.
Shipping Cost
All orders with a shipping cost will use Web Store Shipping Cost Item that has been set in the Store Card for the web store to assign shipping cost to the order.
Note: Make sure the Price Includes VAT check box is selected in the item used for Shipping cost to handle VAT calculation.
Customer Order Setup
When a Customer Order changes status, is shipped, or posted, a web-hook message is sent back to Shopify to update the status of the Order.
- Select the Send LS Commerce Message check box to activate messages.
Watch the video on YouTube to learn more about LS Central configuration:
Other LS Central Setups
Store Setup
- Select the Web Store check box in the LS Commerce FastTab and assign all values needed in the Web Store fields.
Customer Order Setup
- Select the Send LS Commerce Messages check box in the LS Commerce FastTab.
Sourcing Locations
- In the LS Commerce FastTab in the Store Card, enable the Calculate Inventory for Sourcing Locations check box. First, confirm that the Warehouse (W0001) location for the Web Store exists; if it does not, create a new entry in the Customer Order Sourcing Locations table.
Web Service Setup
-
To avoid have to publish and subscribe web services, check Only Local Request.
Debugging
It is possible to debug the communication that goes between Shopify and LS Central.
Open Web Service Setup and in the Logs FastTab, set Server Log Level to All. Then, when LS Central sends a request to Shopify, it will be logged in the Web Request Log which can be found on this page by clicking the Related - Web Service menu. Shopify communications will have the Request ID Shopify-xxxx.