Solid Commerce Integration

Connected Business supports Solid Commerce integration, helping businesses integrate item and order information from Connected Business to the third-party inventory management tool.

The Uploading and Downloading process to and from Soild Commerce and Connected Business uses the Connected Business Job Service Manager. Before running these job through the Job Service Manager, you first need to set up the Job Service Engine. To set up Job Service Engine, refer to Configure Job Service Manager.

 

Set Up Solid Commerce Account

You must first set up your account with Solid Commerce before integrating it with Connected Business.

Set up Solid Commerce Account

1. Create and login to your account at Solid Commerce: www.solidcommerce.com
   
   
2. From the Solid Commerce dashboard, click Products ► Inventory Manager.
   

   Click Image to Enlarge

   Then click the Add dropdown button and then select New Warehouse.

   

   Click Image to Enlarge
   
   

3. Upon completion of the previous process, select New Market List from the Add dropdown button in the Inventory Manager screen.
   
   
4. Create a new market list for these marketplaces: eBay, Overstock, Half.com, Yahoo.com, My Store, Buy.com. Click New Marketplace on the dropdown list.

Set up Connected Business Integration with Solid Commerce

In order to accommodate your account with Solid Commerce, you need to set it up within Connected Business.

1. From the eCommerce module, click Solid Commerce (Beta) ► Account. You will be prompted to indicate your AppKey and SecurityKeyon the Account window.
   

   After getting an account from Solid Commerce, they will provide your Web Services Key and Dev Key. These two keys should be set up in Connected Business Account form (see image above). Enter the Web Services Key to the App Key field and the Dev Key to the Security Key field.

   
   
2. Set up Data Mapping. After registering your account, go to eCommerce Module ► Solid Commerce (Beta) ► Data Mapping. The Solid Commerce Data Mapping Wizard will be displayed. This will allow you to map Connected Business Locations, Shipping Carriers and Shipping Carrier Services. Click Nextto continue.

   On the Mapping section of the Solid Commerce Unified Wizard, select a Solid Commerce Location, Carrier and Carrier Service for each corresponding Connected Business equivalent. Click Next to continue and until you complete the wizard.

   

   Click Image to Enlarge
   
   

3. Set up Market Lists. Specify the market lists to let you upload items to. Make sure that the market lists exist and have been set up in Solid Commerce. Go to Solid Commerce (Beta) ► Marketplace. The Marketplace window will be displayed.

   To create a new market list, click the New button from the menu options. The Detail tab will be displayed. From this form you may enter the information for your preferred marketlist.

   Field	Description
   Marketplace	Specify the Marketplace by selecting from the available marketplace listed below: Any, Amazon, Half, eBay, Yahoo, MyStore, Overstock, YahooStore, AmazonSilverSeller, Buy and Sears.
   Active	When checked, this option allows the selected marketplace to be available on the list.
   Order Download Type	This option is used when downloading orders to and from Connected Business and Solid Commerce. You can select from the following options: Batch - This means that all orders downloaded from the marketpalce at the same time are consolidated in one order in Connected Business. The value set in Default Customer, Source, and Payment Type options are used in the consolidated order. Individual - This means that all order downloaded from the market place at the same time are created one by one in Connected Business. Customer that has the same email in Connected Business will be used in creating the order, otherwise, a new customer will be created.
   Source	Specify the source for the marketplace on the list of active sources.
   Default Customer	Specify the default customer for the marketplace.
   Payment Type	Specify the type of payment for the selected marketplace.

   
   
4. Set up the Connected Business eCommerce web services to be used later when uploading the images. You may refer to Set Up Store and Admin Site.
   
   
5. Set up the items that will be used later for uploading to Solid Commerce. Make sure that the items has free stock. You may refer to Set Up New Inventory Items and Edit and Maintain Inventory Item Information.

Upload Items from Connected Business to Solid Commerce

You need to create a new job plan in order to upload items from Connected Business to Solid Commerce.

To do this,

1. Go to System Manager ► Job Manager ► Manage Job Plans. See Create New Job Plans to learn more on how to create new Job Plans.
   
   
2. Connected Business has built-in job items, select Upload Items from the Available Job Items. Right click on the selected job item and select Settings from the options.

   Click Image to Enlarge
   
   

3. The Settings form is where you specify the warehouse and market place where you want to upload the items. You also have an option on what pricing to upload (Retail, Suggested Retail and Wholesale). In the Criteria section, you can use this if you want to filter the items to upload by Category Code, Department Code, Item Name and Manufacturer Code.

   Click Save and Close to apply changes.

   Tab	Field Name	Description
   Pricing	Default Price	Select where the item pricing should come from: Retail, Suggested Retail or Wholesale.
   	Use Price List	When checked, the item price will come from the price list selected.
   	Price List	The prices in the selected price list will be used by products that are uploaded in Solid Commerce. The following conditions affect the price used. If a product has quantity breaks, the first break will be used. If a product has multiple units of measure, the base will be used. If the product is not in the price list, the default price above will be used.
   Warehouse	Upload products to the following Solid Commerce Warehouse(under the SC Warehouse column) mapped to its corresponding Connected Business Location(in the Mapped to column).
   Criteria	Add criteria when uploading items to Solid Commerce.
   Marketplace List	Select the marketplace list you want to upload the items.

   
   
   

   Click Image to Enlarge
   
   

4. Click Next to continue until wizard is complete.
   
   
5. Approve the Job Plan in order for it to run in your system. Make sure that the job service is still running in order for the job plan to execute.

   To approve a job plan, you may refer to: Approve Job Plans

   

   Important reminders when uploading items to Solid Commerce:
   
   1) When one item returns an error during upload (assuming that you have set to upload more than one item), the service will proceed to the next item and the error will be logged.
   
   2) Weight should not be in decimal values.
   
   3) Weight in Connected Business will be converted to Ounces (oz) when uploading to Solid Commerce.

   
   
6. If there are errors encountered during the upload it will be logged and shown in the eCommerce ► Solid Commerce ► Service Error Log Viewer for reference.
   
   
7. Open the job plan and set it to Inactive.
   
   
8. Check the following fields in Solid Commerce if the data was uploaded correctly. Make sure the Warehouse is correct.
   
   

   Solid Commerce Fields	Connected Business Fields
   Product Name	Item Name
   SKU	Item Code
   UPC	CB UPC Code from base unit of measure(UM)
   Origin of Country	Country of Origin
   MSRP(Manufacturer Suggested Retail Price)	Value uploaded depends on what pricing (Retail, Suggested Retail, Wholesale) was set in the Settings form during the creation of the upload item job plan. The system recognizes the following schemes: If Pricing = Retail, then Connected Business uses the retail price. If Pricing = Wholesale, then Connected Business uses wholesale price. If Pricing = Suggested Retail, then Connected Business uses suggested retail price.
   Manufacturer	Manufacturer Code
   Main Image	InventoryOverrideImage Filename
   Product Description	Web Description
   Cost	If the defined costing method is Standard Cost, then Connected Business will get the Standard Cost. Otherwise, the system will get the average cost.
   Qty	Free Stock Computation is: FreeStock = UnitsInStock – UnitsAllocated
   Warehouse	Warehouse Code
   For Metric System Measurement
   Weight	Weight(kg) * 35.2739619
   Width	Width(cm)
   Height	Height(cm)
   Deep	Length(cm)
   For English System Measurement
   Weight	Weight(lbs) * 16
   Width	Height(IN)
   Height	Width(IN)
   Deep	Lenght(IN)

Upload Item Free Stock / Cost from Connected Business to Solid Commerce

Similar with uploading items into Solid Commerce, you also need to create a new job plan to upload item free stock cost.

1. Go to System Manager ► Job Manager ► Manage Job Plans. See Create New Job Plans to learn more on how to create new Job Plans.
   
   
2. Connected Business has built-in job items, select Upload Item Free Stock / Cost from the Available Job Items. Right click on the selected job item and select Settings from the options.

   Click Image to Enlarge
   
   

3. The Settings form is where you specify the warehouse where you want to upload the item free stock cost. In the Criteria section, you can use this if you want to filter the items to upload by Category Code, Department Code, Item Name and Manufacturer Code.

   Click Save and Close to apply changes.

   Tab	Description
   Warehouse	Upload item free stock / cost to the following Solid Commerce Warehouse(under the SC Warehouse column) mapped to its corresponding Connected Business Location(in the Mapped to column).
   Criteria	Add criteria when uploading items to Solid Commerce.

   
   
   

   Click Image to Enlarge
   
   

4. Click Next to continue until wizard is complete.
   
   
5. Approve the Job Plan in order for it to run in your system. Make sure that the job service is still running in order for the job plan to execute. To approve a job plan, you may refer to: Approve Job Plans
   
   

   You may view the job plan from the System Manager Module ► Job Manager ► View Calendar.

   
   
6. If there are errors encountered during the upload it will be logged and shown in the eCommerce ► Solid Commerce ► Service Error Log Viewer for reference.
   
   
7. Open the job plan and set it to Inactive.
   
   
8. Check the following fields in Solid Commerce if the data was uploaded correctly. Make sure the Warehouse is correct.
   
   

   Solid Commerce Fields	Connected Business Fields
   Product Name	Item Name
   Cost	Value uploaded depends on the costing method specified in Connected Business. If the costing methods are Average Cost, FIFO and LIFO then the average cost value will be used. However, when the costing method is Standard Cost then the standard cost value will be used.
   Quantity	Free Stock

Download Completed Orders from Solid Commerce to Connected Business

Similar with uploading items into Solid Commerce, you also need to create a new job plan to download completed orders from Connected Business to Solid Commerce:

1. Go to System Manager ► Job Manager ► Manage Job Plans. See Create New Job Plans to learn more on how to create new Job Plans.
   
   
2. Connected Business has built-in job items, select Upload Item Free Stock / Cost from the Available Job Items. Right click on the selected job item and select Settings from the options.

   Click Image to Enlarge
   
   

3. The Settings form is where you specify the marketplace on where to get the completed orders from Solid Commerce. If there are no settings specified then no orders will be processed.

   Click Image to Enlarge

   Click Save and Close to apply changes.
   
   

4. Click Next to continue until wizard is complete.
   
   
5. Approve the Job Plan in order for it to run in your system. Make sure that the job service is still running in order for the job plan to execute.
   To approve a job plan, you may refer to: Approve Job Plans
   

   You may view the job plan from the System Manager Module ► Job Manager ► View Calendar.

   
   
6. If there are errors encountered during the upload it will be logged and shown in the eCommerce ► Solid Commerce ► Service Error Log Viewer for reference.
   
   
7. Take note of the following when downloading orders from Solid Commerce:
   
   

   Make sure to configure all shipping methods carrier services in Connected Business.
   
   Only the orders that has Shipped statuses can be downloaded from the market place in Solid Commerce.
   
   Shipped orders in Solid Commerce are converted to invoices in Connected Business.
   
   Downloaded manufacturer and country of origin should already be existing in Connected Business.
   
   When the item of Solid Commerce does not exist in Connected Business, it automatically uses the NONSTOCK item and the item description value is a combination of SKU and Title of the Solid Commerce Order Item.

8. Open the job plan and set it to Inactive.
   
   
9. View the invoices created in CB and check the following fields:
   
   

   Solid Commerce Fields	Connected Business Fields
   Solid Commerce ID	Alternate Order #
   Order Total	Due Total
   SKU	Item Code
   Product Name	Item Name