OScommerce channel integration user manual

The osCommerce Connector is an application which is embedded in Linnworks, and developed and supported by eBusiness Guru Ltd.

• Log into Linnworks.net
• Select Settings in the left-hand menu bar

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

• Locate osCommerce on the list, and click Integrate.

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

• Enter your osCommerce account name to start the integration, then click Next.

• After reading the Disclaimer, please tick I agree to the terms and conditions and click Next to continue integrating osCommerce.

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

API Settings

• Username and Token will be provided by eBusiness Guru at the time of installation.
• Order Status will be set as Pending as default.
• Base URL enter your website URL.
• Order Processed Status is set as Delivered by default.

• To complete the integration, click on Finish. Your OSCommerce integration should now show in Linnworks.net under Channel Integrations.

Account Status

• In Linnworks.net, click Settings.
• Select Channel Integration.
• Locate the osCommerce entry, and click the Configuration button.
• To Enable or Disable the Account, locate the Account section.
• If the Enabled option is unticked, 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 osCommerce 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, click Settings.
• Select Channel Integration.
• Locate the osCommerce entry, and click 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 osCommerce 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.

Note that 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 osCommerce. 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, click Settings.
• Select Channel Integration.
• Locate the osCommerce entry, and click the Configuration button.
• In the Listings section, the information reflects the information Linnworks currently has about your listed items on the osCommerce marketplace.

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 osCommerce channel integration. Linnworks downloads orders from osCommerce with the status Shipping in Progress.

• In Linnworks.net, click Settings.
• Select Channel Integration.
• Locate the osCommerce entry, and click the Configuration button.
• In the Order section, there are two options.

Dispatch Notes, when enabled, allows Linnworks to send information about orders that have been Processed in Linnworks. Orders that are Processed in Linnworks are updated to the status Manifested on osCommerce.

The Order Sync Date reflects the date and time of the last successful order download and update for the osCommerce 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 osCommerce account to connect, and are covered in Step 1. Click Save at the bottom of this window to apply any changes.

Mapping

Linnworks uses the Mapping Tool to ensure that it knows which SKUs in its inventory are connected to which listings on osCommerce. 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, click Settings.
• Select Channel Integration.
• Locate the osCommerce entry, and click the Mapping button. This screen is divided into two sections.

On the left are the listings Linnworks is aware of on your osCommerce 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, Linnworks can link them all for you.

• Click the Settings button (in the top left hand corner with a cog/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 the Link button beside it with the listing highlighted.
• Repeat for other listings to be linked manually.

 

Creating Linnworks Inventory items and Mapping

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 Create.
• 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 osCommerce.
• 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 osCommerce.
• Enter the SubSource as the name of the osCommerce channel.
• Enter the Price.
• Click on + Add to complete.
• If there is already an entry present for the correct Source and SubSource, double click the Price to edit it, and then click Enter.
• Close the SKU window when you have finished.

 

• In Linnworks.net, click Settings.
• Select Channel Integration.
• Locate the osCommerce entry, and click 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 drop-down list and select which inventory/fulfillment location will initially receive the orders from the osCommerce integration.
• Under Inventory Sync Locations, you control which Linnworks Inventory locations are used to calculate the Available Stock values for your osCommerce 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 the 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 to update Linnworks. You should also click Save at the bottom of the configuration window to apply any changes.

The next step is to map your osCommerce Shipping services to Postal Services in Linnworks, so orders don’t need to have their Postal Service set manually. Initially, all are mapped to Default.

• In Linnworks.net, click Settings.
• Select Channel Integration.
• In the Edit Shipping Allocation window, you should have an empty list.
• To add a new entry for one of your osCommerce shipping services, click on Create New.

 

Create New Shipping Service Mapping

• For Channel Service Name, enter the name of the Shipping Service in osCommerce.
• In Channel Service Tag, enter the Tag Value used for the service in osCommerce.
• In the Linnworks Postal Service drop-down list, select the name of the Linnworks Postal Service that should be used for orders imported from osCommerce, with the Shipping Service to dispatch them correctly.
• The Add button will save the mapping, and display it in the Edit Shipping Allocation screen.
• Repeat this for all the other osCommerce Shipping methods you are using..
• Click Save at the bottom of the channel integration window to apply any changes.

Click on the payment mapping icon to open the payment mapping screen.

• Edit the Payment Methods screen as displayed below:

• Create a new payment screen as displayed below:

• Add new payment screen will be displayed as below:

 

Delete Payment Mapping:

• Select the payment service you wish to delete, then click on Delete.
• Once payment service mapping is deleted, click Save.