1. Home
  2. Point-Of-Sale Software
  3. Update HQ from SO

Update HQ from SO

I know this question has been asked before, however, I just wanted to float it one more time before I ramp up my development efforts.

Currently, the HQ/SO model does not support adding new items at the SO level such that those new items propogate to HQ and then on to other stores. The model requires all new items to be added to HQ first and then pushed to the stores.

At the moment my client heavily uses MC50 handhelds and a software package that connects only to an SO database. They receive all of their product in their stores and add new items immediately through the handhelds. It is an incredibly efficient process for them.

I need to integrate them into the HQ environment and, at the moment, that will require me to break their process. Now items will have to be set aside or noted and it will be someone's job to collect that information and enter it into the HQ DB. Probably, I will have to put extra hardware, that's not handheld-based, in their environment and require them to input new items only at those locations.

This is not satisfactory to my current client. It's not satisfactory to me either.

So, one last time (for me at least :) ), is there any existing product that fixes this hole in RMS? Retail Realm does have a product that's close, but it is not handheld based so that one is out. Are there any others?

If there's nothing, then I've got to get started writing the code :).

Reply to
dwtalso
Loading thread data ...

If you want help :) I'm available .. but it's possible to put items into HQ from SO through trigger, table sync and TSQL queries .. it's not impossible but not easy (because you need to create the item on HQ before item movements in database store ...)

cod

Reply to
cod

We have an application (not using triggers that slows the system) that allows you to create items. It connects from store direct to HQ and 1st creates the Items at HQ brings their HQID to Store and creates them atthat store. Also it allows you to create a Worksheet 250 automatically to send that item to other stores. This is Item Creation which is part of the Fashion Bundle (though not necessarily just fashion items). If you have more questions contact me.

Reply to
Afshin Alikhani

Afshin,

I'm aware of that application. However, I spoke with someone from Retail Realm yesterday and it will not support using handheld hardware. Right now I would rather give my client a solution that continues to support the use of those devices.

Thanks for the reply, though :)

Dan

"Afsh> We have an application (not using triggers that slows the system) that

Reply to
dwtalso

Thanks, I'll let you know if I need help. I might :).

I thought of using triggers. I'm more inclined right now to create a service or a scheduled task to keep the overhead on the server at a minimum and also to keep my fingers out of the database in case future updates modify it.

The setup I'm working with has the SO and HQ db's on dedicated back office servers, separate from the registers, so I've got plenty of power to run a background operation occasionally. And the inter-store network is VPN-based so I'm not worried about a robust client-server scheme that HQ Client/Server uses.

Anyway, we'll see how it goes :).

"cod" wrote:

Reply to
dwtalso

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.