Topic Options
#24936 - 07/10/07 02:56 PM Client History
DaveS Offline
Junior Member

Registered: 07/10/07
Posts: 4
Loc: Lebanon, New Hampshire
How do I go about entering a client's purchasing history to the order manager? It would be nice to be able to upload an excel spreadsheet with the applicable information for several companies at a time, but I would settle for a way to do even a single company. Sort of an "import data" function to match the "export data" function.

Top
#24937 - 07/11/07 04:01 AM Re: Client History
Anonymous
Unregistered


Hi Dave,

Assuming you have done a default installation of PSW, including MySQL:

The MySQL database can be fully accessed (from local system only by default) and modified.

Ofcourse you will have to identify the fields and match them to your existing database, but that is a one-time job. After that, you can realise even a scheduled synchronisation of your user base if you would want to, or create a registration form on your website that will create new users.

We offer with PrintShop Web the building blocks based on open standards, you can modify the database contents, so you can use any means that can write to the database you can imagine.

A great (free) tool to view the PSW database contents can be downloaded here:
http://www.mysql.org/downloads/gui-tools/5.0.html

Kind regards,

Floris

Top