1. Home
  2. Point-Of-Sale Software
  3. Synchronizing Item DB between POS and backoffice

Synchronizing Item DB between POS and backoffice

In my backoffice i use a copy of my POS item database. I mainly use it to print mass labels and to process my online orders. This database is not connected in any way to the POS database.

What I would like to do is to synchronize the items table between POS and backoffice. I just would like to get all new or updated items from the POS maybe once a week, or whenever i know i made changes to the POS items table.

Is there an easy way to get this done? I don't want to just restore an entire backup as I would loose my online order payment processing.

Both systems are on RMS 2.0 latest support pack.

Reply to
Gerd
Loading thread data ...

Mmm,

Is there a reason why you dont install the Store Operations administrator/ manager at back office so that you can connect to the online POS database ?

I am not sure whether there is an easy way to synchronize 2 tables in database The hardway would be:

  1. export the item table content . i think use a bcp command line utility that comes with SQL server installation
  2. Import back usig the same bcp utility at the target machine

But this would be one way synchronization

rgds, Joie

Reply to
Joie

Thanks for your reply, Joie.

I have the SO adminitrator installed on the backoffice system. The main reason I don't want to connect to the POS database is that all my online orders are processed in Quickbooks. Only the credit card processing is done in the backoffice POS.

Every day I extract all the sales and tender details from the POS and load those into Quickbooks as well. Connecting the backoffice to the POS would give me wrong tender totals, as for the online orders i would not have the sales to go with it.

Is the bcp utility also part of store operations or only part of a full SQL server installation? I only have store operations but not a full SQL server installed on the backoffice pc.

Reply to
Gerd

I am using SQL server 2005 standard edition On my machine the bcp tool is located at C:\Program Files\Microsoft SQL Server\90\Tools\Binn

Reply to
Joie

Thanks Joie, I'll check it out.

Reply to
Gerd

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.