automatic price & stock updates from Pastel Partner to MySQL website?

**Salad_Dressing** · 28-Sep-11, 03:19 PM

We are running Pastel Partner version 11 (build 11.2.1) and I am putting up a webpage for our business (HTML with PHP and MySQL backend).

Is there a way to automate updating of product prices and stock count from Pastel Partner to the MySQL database?

Any help would be greatly appreciated!

Thanks in advance.

**Neville Bailey** · 28-Sep-11, 05:57 PM

Unfortunately my knowledge about MySQL databases is negligible, so I can't comment on that aspect of your query.

However, if you have Pastel's Business Intelligence Centre (BIC) module, you can extract the relevant data from the Pastel database into an Excel format. From there it may well be possible to transfer the data into a MySQL database, but you might be better qualified to answer that question.

**Dave A** · 28-Sep-11, 08:49 PM

Originally Posted by Neville Bailey

However, if you have Pastel's Business Intelligence Centre (BIC) module, you can extract the relevant data from the Pastel database into an Excel format.

Can it be extracted as a csv or XML file by any chance?

**Neville Bailey** · 28-Sep-11, 08:54 PM

Originally Posted by Dave A

Can it be extracted as a csv or XML file by any chance?

Not directly from Pastel, but a macro button can be embedded into the BIC Excel report to generate a CSV format file.

**Dave A** · 28-Sep-11, 09:21 PM

Surely Pastel has a connector app for third party plug-in developers?

**Neville Bailey** · 28-Sep-11, 09:23 PM

Originally Posted by Dave A

Surely Pastel has a connector app for third party plug-in developers?

Yes, it does, but one has to find the right Pastel-accredited 3rd Party Developer. Here is a list of them.

**Dave A** · 28-Sep-11, 09:40 PM

I hear you about the "authorised" bit, but ...

Salad_Dressing - do a Google search for pastel sdk download and see if you can find the relevant version. If you tack on free at the end of that the result does change a bit.

**Salad_Dressing** · 03-Oct-11, 11:21 AM

Thanks all for your inputs into this matter. Here's what I have found...

Pastel can output spreadsheets and I can easily script to rip and update my database with them. However that does not fully automate the process.

a link to Pastel Partner 3rd Party Developers

a link to Pastel SDK download

I installed the SDK to see what sort of language I'll be getting myself into and I see examples in VB6 (Visual Basic?)

Anyway, I was really hoping for some sort of scripting language which can hook into Pastel Partner in order to perform my functions to our website's database. I find it hard to believe that in the Internet age there's no way to automate stock counts and price changes in a fairly easy way???

Here's another approach, perhaps...

Can Pastel Partner be set up to create scheduled CSV exports, let's say each half hour? I can then write code to pick up the latest CSV file, parse it, and update the online database.

**Salad_Dressing** · 03-Oct-11, 11:59 AM

The other thing I want to ask is this: Can Pastel Partner be queried from outside via an online connection to obtain relevant stock and pricing information, much like one would query a database?