
Selling products online generally requires much more product information than what is available in accounting / ERP systems to gain consumer trust.
For example, the extra data required for products is:
Plus there are the different category trees such as product type or brand.
Making things slightly more complicated is that the availability of this data varies from system to system. For instance, MYOB Account Right Classic only offers a 256 character product description field which can be very limiting and only 3 custom data fields that are often used for logistics or internal purposes.
Other systems such as Jiwa are far more comprehensive and allow you to create lots of custom data fields. That said, many systems cannot support the advanced data structures such as parent/child combinations used for colour / size selection or product attributes used for smarter searching.
All this data needs a home and it needs to be managed over time. Consider a new range of products you want on your website. You have added them into your accounting / ERP system and the core data has synced the products to the website. The trouble is, users cannot easily find these new products because most of the extra data above is not yet set.
Traditionally, our clients used the TOTECS Admin Centre to either set this data for each product individually or import bulk data managed in spreadsheets. This is not a bad approach but it becomes difficult to manage for inventories larger than 1000 products.
Product data management becomes very difficult when companies have teams of people managing product data for large inventories. Often spreadsheets become out of sync or people do not enter data correctly or they import data and clobber the work someone else has done.
The TOTECS Connector installed on your server that syncs data from your accounting / ERP system has a little secret that I am about to share with you. It contains a tab called Datasets. This is like the ultimate Excel and database tool rolled into one.
A dataset is a product driven database that offers table views like Excel but contains smart data filters and bulk editing tools that saves bucket loads of time. It's powerful because:
Better still, if you add new products to your accounting/ERP system, you can filter these products instantly and add the essential data for your TOTECS website.
Step 1: The process to start managing data is as follows:
Step 2: The process to sync datasets to TOTECS is as follows:
Our TOTECS Integration Partners can assist you to create and configure your data sets. They can assist you to develop a data management plan that specifies what data is managed between your accounting/ERP system and the datasets. They can then create and configure the datasets to sync with TOTECS as given in steps 1 and 2 in the previous section. They can offer over the phone training, support and guidance as required.