One Database

[JEFFgse]

Hi

If You Are Running A multi site ,

1- How can you have one database , so if you change a price or description in a product ( as you sale x-reference items ) the database all the sites are changed automatically ?
2-Be able to get the Stock up to date ( as you sale x-reference items )
3-Be able to import to QuickBooks Pro From the Single Database?


Consider I have A Product which I sale @ site 1 ,3,5, and 9 . If I am changing the price , I have to go to each site and change the price manually. I have to import from each site to my account package.

Surely their must be an easier way ?

Thank for any help

[wjcampbe]

Read up on External Linking in the built in Actinic Help | Help Topics. Then think outside the box to adapt to your own needs.

[Jan]

As Bill said, use External linking to link the product details but I think you will still have to export from each site into Quick Books.

Regards,

[dallen]

External Links 'would' be the perfect option for you and me both...

Except it slows things down so much it makes Actinic unusable.

We now have Excel spreadsheets set up to pull data from our central data source (SQL DB) that get saved as CSVs for import into actinic. That way any price, description, stock updates get done once then you just need to open the spreadsheet, let it update itself with the external data, save as CSV, import into Actinic then upload the website. Works out a LOT faster than using Actinic's ropey External Linking feature...

<edit>

But you'll still have to import from each site into the accounts package...

[Darren B]

Except it slows things down so much it makes Actinic unusable.

That old chesnut, i find it funny that so people have real issues and other not, not sure anyone ever got to the bottom of it completely but i also belive the updats and new versions are suppose to help (suppose)

Jans tools are great for doing this, i did trial it but i use sage for accounts and use the stock control and just update each site. That saying i have never managed to get the full link to work properly, no descriptions, prices, images e.t.c then again probably the way i was doing it. Could revist it sometime.

D