Using and Integration with DEAR Systems

[lloyd_borrett]

G'day,

Is there anyone in the Zen Cart community using the inventory management solution from DEAR Systems (www.dearsystems.com)?

I'm looking for a way to significantly improve this area of my business. Right now DEAR is looking good, but alternatives might be Unleashed or Vend.

I'd be interested in advise from anyone using such a 3rd party solution.

Has anyone integrated DEAR with Zen Cart?

If no such integration add-on exists, is there one that you think might make a good base to start from when creating one for DEAR?

Best regards, Lloyd Borrett.

[lankeeyankee]

You are having issues with inventory management? Are you selling through multiple online channels and/or brick and mortar and are having trouble keeping your inventory straight? What accounting software do you use? And what are your overall goals from using a 3rd party system like this one and how do you plan to deploy it (will it be your main business control hub? Or a peripheral application and if so, what are you using for your main business control?)

[lloyd_borrett]

You are having issues with inventory management? Are you selling through multiple online channels and/or brick and mortar and are having trouble keeping your inventory straight? What accounting software do you use? And what are your overall goals from using a 3rd party system like this one and how do you plan to deploy it (will it be your main business control hub? Or a peripheral application and if so, what are you using for your main business control?)

We are having major issues with purchasing and inventory management. Part of the solution will be to support SKUs properly within Zen Cart, but that won't go far enough. We currently have some 3000 Zen Cart products, and I estimate it's about 15,000 SKUs. Part of the solution will be using barcoding, including assigning barcodes to products that don't have them and labelling unlabelled products.

We currently only sell through Zen Cart online. But the option to sell via Amazon and/or eBay is something we'd like to do within a year. DEAR should make this possible.

Our bricks and mortar store is 30% of our business. We don't have POS but would like to have it. DEAR is currently adding this feature, so that could mean less integration points required.

We use Xero for accounting with no integration to Zen Cart. DEAR integrates with Xero.

As fulfilling orders from Zen Cart is 70% of our business, that's the system we use to process orders and communicate with customers.

Since I took over four years ago, the business has grown 600%. (That's not from scratch but from a successful business that started in 2002 and went online in 2006.) Growth online was 40% for the financial year ending 30-Jun-17.

Efficiently handling purchasing and introducing proper inventory control is essential for the business to continue to grow. (We should have done it last year.) It's now the major pain point for the business.

We import some products from manufacturers and sell them under our own brands. We also import and distribute some brands as the local wholesaler. We mostly resell products from local suppliers. Some of them direct ship for us.

Initially we'd probably continue to use Zen Cart for our interface with clients and main business control hub. But maybe this would change if a 3rd party solution like DEAR, properly integrated with Zen Cart and provided a better solution.

Best regards, Lloyd Borrett.

[DrByte]

Square has POS and inventory-mgmt capabilities, and could be integrated to sync Zen Cart inventory with their inventory so POS sales could link up and keep inventory counts accurate.

I realize that doesn't handle the purchasing side.

Xero can probably be integrated with ZC. Depends what their tech requirements are.

[lloyd_borrett]

G'day,


People have asked about the problems I'm trying to solve. So here goes...


Zen Cart out of the box doesn't handle stock keeping units (SKUs) unless we set up every SKU as a separate product. If standard Zen Cart attributes are used and a product has say four sizes and five colours, then there are 20 SKUs. But Zen Cart doesn't have the manufacturer and EAN/UPC codes for these SKU's. Thus Zen Cart has no idea if we have say a red coloured fin in size large in stock, just that we have 18 units of those fins.


Of course Zen Cart doesn't let you assign an image to a SKU. Yes we can have multiple images per product, but there is no way to assign labels for each image. Other ecommerce systems do this and for good reason. It helps the online shoppers see the attribute options more clearly and results in more sales.


We end up having to invent a product code to cover all of the SKUs of a product. Then we can't automatically update prices when we receive a new price list from a supplier, especially when prices vary by attribute. When you have so many products and suppliers, this becomes a real business pain point.


Step one for us to achieve a more streamlined business will be to add proper support for SKUs to Zen Cart (there are addons to do this), or switch to a different ecommerce platform. Then we can integrate our online store with the purchasing and inventory control system and/or POS systems we also need.


Note: My advise to those setting up a Zen Cart store selling products with lots of attributes like size and colour is that you should add support for SKUs from the beginning. Retrofitting it later, like we're going to have to do, is very problematic.


We need a purchasing system to improve our entirely manual process of ordering and receiving product. Such a system will also help us to properly label many products when we receive them, which will help with identifying the right product when picking to fulfil orders.


For us, some products must be shipped from instore stock. Some can be shipped to customers direct from suppliers because we don't keep them in stock and the supplier will drop ship for us. Some it's optional to ship from suppliers or stock. Some we don't keep in stock and have to order them in from suppliers in order to then ship them to customers. This is something staff have to know when picking and purchasing product. A purchasing and stock control system would handle this better.


A purchasing system will let us use the unique details for each SKU when ordering product from suppliers. We'll know how many of each SKU we have, and it's cost price.


A purchasing and inventory control system will let us make better decisions about the stock levels we keep, plus better use of incentives from suppliers when buying stock. With better control of stock levels we can provide a better service to our customers.


We have a physical shop which is 30% of the business. Having a POS would streamline instore sales. With a POS interfacing with Zen Cart and a purchasing/inventory system, it will help with inventory control and adding/updating product prices, etc. across all business systems.


Best regards, Lloyd Borrett.

[lankeeyankee]

I asked the various questions to see how the solution we use might apply to your situation. I think it could work very well for you although there are some commercial addons and services involved. My system is still a work in progress which I will explain shortly. I don't know what you may or may not have installed so I am just listing everything we use.

We have the same type of setup as you, almost identical with your description. We have many products with many attributes and many of the attributes affect prices. We drop ship certain products, other products we can drop ship if we do not have sufficient quantity on hand, and yet others need to be shipped to us before then ship it on to the customer.

We are using Quickbooks Enterprise instead of Xero. QBE can "almost" auto create purchase orders (you have to click a button in a report for the purchase order to be created) based on the stock settings per item. For drop shipped items our minimum stocking quantity is -1 and max is 0. So when a drop ship order is entered it makes the quantity on hand -1 (or however many units were ordered) and triggers the product to be put into a purchase order. Since the max level is set to 0 it will only order enough to cover the drop ship order.

QBE uses item numbers (model numbers) and has a field for MPN and custom fields such as UPC and SKU. It can also be set up with barcodes and connected to a scanner. You can either specify the barcode or it will automatically create them for you. You can create groups of products, so if you sell a kit you can specify individual items and quantities that make up the kit. You can also set up attributes although for my operation I have set up each attribute combination as an individual product with a unique model number since that is how we order them.

QBE also has a receive items page, which can be separate from receiving a bill from the vendor. You receive items against the purchase order or bill, receiving against the PO makes it easier to track backordered items. You can use your barcode scanner to speed up receiving. You can have the barcodes on packing lists, too. And you can create separate pick tickets with bin locations to help warehouse staff accurately and quickly pick the correct items.

You can also enter lot and/or serial numbers if you need them. We personally don't need either so I have not tried it. QBE also has a fixed asset section to help automatically figure out depreciation and amortization.

We use a service called T-Hub to import orders from ZC into QBE. T-Hub has many other features that we do not currently use: you can print shipping labels, change prices and stock levels, print packing slips and invoices, enter phone orders, push tracking numbers in any direction (to QBE, to ZC, from QBE to ZC) plus many other things. It can be used as the controller software for the business but I find the interface to be a bit clunky and mid-90s in appearance. T-Hub also integrates with Amazon, ebay, and many other sales platforms simultaneously and can be configured to differentiate where an order is coming from to make various reports easier to organize. It can push stock changes from QBE to the sales platforms, and it has an auto sync feature to do all of these various tasks in whatever time periods you set. So as you sell something in ZC, it imports it into QBE and then pushes to stock changes to your other platforms and vice versa. T-Hub also integrates with Quickbooks POS, and Quickbooks POS integrates with QBE. In fact, I believe that QB POS is supposed to have better inventory control especially for attribute heavy items. I have never tried it so I do not know.

One of the best features for us regarding T-Hub is the interface between it and ZC is in PHP and resides in the ZC admin directory. I wrote a custom function that maps custom fields I added to the attributes controller in ZC. The custom fields are for SKU and SKU quantity. Sometimes the SKU will be the base model number with something appended to the end, such as Widget1RD for red or Widget1BLK for black. Sometimes the attribute will actually be an additional line item such a gasket or different types of screws to mount the item. The function can do either thing very easily. It can also specify if there needs to be multiple amounts, so for instance something might need 2 screws and another thing needs 3. In the QBE or T-Hub packing list and invoice it will show whatever quantity specified and the new line item if it is one. Or if in ZC the SKU needs to be different from the model, it can do that, too.

The Ceon Advanced Shipper module is perfect for drop shipping and setting specific shipping rules by category, manufacturer, model or a combination of all 3. It is incredibly flexible and for us it is indispensable since we sell oversized items that can't qualify for free shipping and we sell internationally.

The drop ship purchase orders module in ZC can automatically email a PO to a vendor when an order is placed.

There are several attribute stocking modules for ZC, SBA in the downloads section and a couple commercial ones. I have been using the Numinix Variants module. They have changed their modules to SaaS with monthly fees so I probably would find a different one if I were just starting with it. But I have found that it is much more feature rich and can set some attributes as stockable while others have no bearing on stock levels. And it can show the stock amount on the product info page, and show a variant as out of stock. Stock levels can be set per variant combination. You can also enter a SKU per variant and import and export the list with CSV files which are incredibly handy for doing bulk work. I am sure there are other modules that can do the same or similar that don't have the monthly fee.

I believe there is a module for attribute image swapping in the downloads section.

Now, for the current limitations I am working on fixing. Currently, I cannot push stock changes to ZC for the items with attributes. I need to custom code a function for T-Hub that will map to the Numinix variant DB table. I also cannot bulk change attribute prices in ZC. I can do bulk price changes in QBE, so I need to also map the communication from QBE through T-Hub and to ZC so prices can be pushed from QBE to ZC. I am not using any one program as the master controller yet due to getting the communication between everything bi-directional. We print labels and update order status in ZC, we do customer emails through a ticket system (osTicket which is open source), payroll is done through an online payroll service instead of through QBE due to cost, phone orders are run through ZC instead of QBE or T-Hub. So, I have not yet gotten the system completely smooth to where one program is the master and everything else is a slave that has little to no direct interaction. But that is my ultimate goal. I would like to use QBE to run everything but processing cards through them is not as cheap as a different merchant provider. T-Hub would probably be the best option if it wasn't so dated and a bit clunky to work with all day long.

My overall point in this super long post is you can definitely get to a much better place than where you are. Even if you don't use anything I have outlined, I think you will find that you can put it all together in a way that works for you. If you are into using DEAR and are happy with Xero then ask them if they will provide a connector for you for ZC. If they won't, ask them for their PHP API so you can get someone to write it for you. I can still give you the custom function I wrote because it it pretty generic and ties in with ZC functions which would have to be used in the connector. The attribute controller changes are pretty easy, too.

These are the issues that occur when a business scales up to a certain high level. So I congratulate you on your success and toast your continued growth and even greater success!

PM me if you'd like to get in touch directly to carry on the conversation in greater detail.

Matt

[DrByte]

I've also heard others speak very highly of T-Hub integration between Zen Cart and QuickBooks.