Page 1 of 5 123 ... LastLast
Results 1 to 10 of 47

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

  1. #1
    Junior Member
    Join Date
    Sep 2011
    Location
    Midrand
    Posts
    22
    Thanks
    7
    Thanked 3 Times in 3 Posts

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

    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.

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    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.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  3. #3
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    22,648
    Thanks
    3,304
    Thanked 2,676 Times in 2,257 Posts
    Blog Entries
    12
    Quote Originally Posted by Neville Bailey View Post
    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?

  4. #4
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Quote Originally Posted by Dave A View Post
    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.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  5. #5
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    22,648
    Thanks
    3,304
    Thanked 2,676 Times in 2,257 Posts
    Blog Entries
    12
    Surely Pastel has a connector app for third party plug-in developers?

  6. #6
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Quote Originally Posted by Dave A View Post
    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.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  7. #7
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    22,648
    Thanks
    3,304
    Thanked 2,676 Times in 2,257 Posts
    Blog Entries
    12


    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.

  8. #8
    Junior Member
    Join Date
    Sep 2011
    Location
    Midrand
    Posts
    22
    Thanks
    7
    Thanked 3 Times in 3 Posts
    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.

  9. #9
    Junior Member
    Join Date
    Sep 2011
    Location
    Midrand
    Posts
    22
    Thanks
    7
    Thanked 3 Times in 3 Posts
    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?

  10. #10
    Junior Member
    Join Date
    Sep 2011
    Location
    Midrand
    Posts
    22
    Thanks
    7
    Thanked 3 Times in 3 Posts
    OK, I may have found a solution where the SDK is used through PHP... check out this link on the Pastel Development Zone.

Page 1 of 5 123 ... LastLast

Similar Threads

  1. Replies: 3
    Last Post: 19-Jul-18, 11:49 AM
  2. [Question] Pastel Partner v 9.3.4
    By Martinco in forum Accounting Forum
    Replies: 6
    Last Post: 07-Jan-16, 05:17 PM
  3. Magento website developers - idea on price?
    By Pap_sak in forum Business Online Forum
    Replies: 8
    Last Post: 18-Nov-11, 04:48 PM
  4. [Question] Pastel Partner
    By Goop in forum General Business Forum
    Replies: 5
    Last Post: 15-Aug-10, 06:58 PM
  5. [Question] Help with Pastel Payroll Partner
    By celly007 in forum Tax Forum
    Replies: 3
    Last Post: 17-Sep-09, 10:25 AM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •