Online store with barcode scanner

[Guest]

My client wants an online wine-shop where - when a wine bottle has been sold in his real shop and he scans the barcode of this winebottle - the stock in his online wine-shop applies to that.

I was wondering which of all the online shop-solutions you can get (or buy) have this?
Where can I find more information about that (what is this called anyway)? What exactly is "real-time stock level management system"? Is this what I mean?

I work with Dreamweaver and the Developer Toolbox, is there any "online shop" solution for Dreamweaver. I really like the Developer Box to make the back-end is there something like the Developer Toolbox to make an online store?

Thanks for any tips and further information.

[Newsgroup_User]

"Ullitasch" <webforumsuser@macromedia.com> wrote in message
news:gk37bi$21g$1@forums.macromedia.com...
> My client wants an online wine-shop where - when a wine bottle has been
> sold in
> his real shop and he scans the barcode of this winebottle - the stock in
> his
> online wine-shop applies to that.
>
> I was wondering which of all the shop-solutions you can get (or buy) have
> this? Or where can I find more information about that (what is this called
> anyway)? What exactly is "real-time stock level management system"? Is
> this
> what I mean?

I could be off-base on this, and it certainly wouldn't be the first time :),
but it sounds like wherever his inventory db is stored, the ecommerce app is
going to have to talk to it. And that ecommerce app is going to have to
conform to what his already set up Point Of Sale system is... or there's
going to be a lot of custom SQL/scripting created to "translate" info from
one db to another. I would think the first place to look is to contact his
POS vendor to see if they already have their own ecommerce app to use with
their POS system.

[Newsgroup_User]

Hunter Elliott wrote:
> "Ullitasch" <webforumsuser@macromedia.com> wrote in message
> news:gk37bi$21g$1@forums.macromedia.com...
>> My client wants an online wine-shop where - when a wine bottle has been
>> sold in
>> his real shop and he scans the barcode of this winebottle - the stock in
>> his
>> online wine-shop applies to that.
>>
>> I was wondering which of all the shop-solutions you can get (or buy) have
>> this? Or where can I find more information about that (what is this called
>> anyway)? What exactly is "real-time stock level management system"? Is
>> this
>> what I mean?
>
> I could be off-base on this, and it certainly wouldn't be the first time :),
> but it sounds like wherever his inventory db is stored, the ecommerce app is
> going to have to talk to it. And that ecommerce app is going to have to
> conform to what his already set up Point Of Sale system is... or there's
> going to be a lot of custom SQL/scripting created to "translate" info from
> one db to another. I would think the first place to look is to contact his
> POS vendor to see if they already have their own ecommerce app to use with
> their POS system.

Sounds right to me, the 2 systems need to synchronized so that they both
use the same information. Product SKU, stock level and price are the
main things that need to be the same.

I have built a custom web store for the company I work for, when an
order is placed online the stock levels are adjusted on the online
system, the order is printed off and processed through the in house
system. Every half an hour there is a job run on the in house SQL server
that synch's the 2 systems stock levels.

At the moment we only have a couple of online orders per day, so every
half an hour is fine, but if we were much busier I would do a more
frequent synch.

It wasn't simple, and took time to get perfect, as the in house sales
system is very complex, which is why I am a full time member of staff,
not a contractor.

Dooza

[Guest]

This sounds very clear to me: there must be an synchronisation between the "local" shop database "IN STOCK" field and the online shop "IN STOCK".. So I have to check what they use and then get this connection/synchronisations: any Tutorials for update local (or online) databases with each other or/and also: how could I synchronise automatically for example .xml files with the database?

thanx for all this answers!

[Guest]

This sounds very clear to me: there must be an synchronisation between the "local" shop database "IN STOCK" field and the online shop "IN STOCK".. So I have to check what they use and then get this connection/synchronisations: any Tutorials for update local (or online) databases with each other or/and also: how could I synchronise automatically for example .xml files with the database?

thanx for all this answers!

[Newsgroup_User]

Ullitasch wrote:
> This sounds very clear to me: there must be an synchronisation between the
> "local" shop database "IN STOCK" field and the online shop "IN STOCK".. So I
> have to check what they use and then get this connection/synchronisations: any
> Tutorials for update local (or online) databases with each other or/and also:
> how could I synchronise automatically for example .xml files with the database?
>
> thanx for all this answers!

I use SQL2000 for both of my servers, then on my local server I setup a
linked server, which connects to the online server.

I can then reference my online server using something like this as the
table name: linkname.databasename.dbo.tablename

This allows me complete control from my local server. I use SQL jobs to
execute stored procedures to do the updates.

I am pretty sure you could use XML files but I don't know how, sorry.

Dooza

[Guest]

Thanks a lot. I will check this out.
Is there now solution for Dreamweaver/ .. extensions?

[Newsgroup_User]

Ullitasch wrote:
> Thanks a lot. I will check this out.
> Is there now solution for Dreamweaver/ .. extensions?

No this is something that will need to be hand coded for your specific
situation.

Dooza