Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2008
    Posts
    361
    Plugin Contributions
    0

    Default Connecting to external APIs to pass product information

    I started to learn about the QueryBuilder, because I need to pass product info, just basic, name, description, stock and price to an API in a CRM, but so far I couldn't find more information on the subject of using APIs to connect to external applications, I will probably use a curl method and json to send the data, to the recipient's database, as I already have an automated inventory system, the only thing I need is to pull the data and connect to the other app's API, to pass it, probably using automation as well.

    This process will be in the background, initially for connecting to my CRM, then probably using it to pass data to marketplaces, it's a nightmare to manually fix thousands of products, even using spreadsheets, on a daily basis, so uploading an updated, current, accurate inventory is a must, as I couldn't find any current solutions to do this, I will write my own, just looking for some hints and common practices, about where to look to get the info I need to build the apps.

    Please don't suggest to hire someone, because I am in a dire economic situation, just using my brains and my knowledge to accomplish something by myself.


    [Note: remember to include site URL, ZC version, list of plugins, PHP version, etc ... read the Posting Tips shown above for information to include in your post here. And, remove this comment before actually posting!]

  2. #2
    Join Date
    Aug 2007
    Location
    Gijón, Asturias, Spain
    Posts
    2,062
    Plugin Contributions
    29

    Default Re: Connecting to external APIs to pass product information

    Well, I keep banging on about this...Pentaho Data Integration Community.
    In short it is a method to get data from A, manipulate it in multiple simple steps, then send it to B. A and B can be any database or filetype.
    I use it to extract product data from a dBase legacy system to a csv, then use my own script to get that into my shop db. Pentaho could do it all but I have a lot of oddities that need special treatment and I did that in the script.
    Pentaho can produce a job file that can be run automatically.
    Steve
    github.com/torvista: Spanish Language Pack, Image Checker, Structured Data, BackupMySQL Admin/Auto, Product Listing Sorter, Redsys payment module...

  3. #3
    Join Date
    Jul 2012
    Posts
    14,693
    Plugin Contributions
    17

    Default Re: Connecting to external APIs to pass product information

    EasyPopulate V4 has a cron task that can import a file to the database. Haven't incorporated export directly into a cron task yet. Hadn't really been asked and I haven't had a reason to have it yet.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...
    Upgraded to Zen Cart V1.5.3 from V1.5.1 from V1.5.0 from V1.3.9h

  4. #4
    Join Date
    Jul 2008
    Posts
    361
    Plugin Contributions
    0

    Default Re: Connecting to external APIs to pass product information

    Quote Originally Posted by torvista View Post
    Well, I keep banging on about this...Pentaho Data Integration Community.
    In short it is a method to get data from A, manipulate it in multiple simple steps, then send it to B. A and B can be any database or filetype.
    I use it to extract product data from a dBase legacy system to a csv, then use my own script to get that into my shop db. Pentaho could do it all but I have a lot of oddities that need special treatment and I did that in the script.
    Pentaho can produce a job file that can be run automatically.
    Well Torvista! Thanks for the tip! I'll look into Pentaho, I was looking at some solutions, my idea was to query the db, and then with the data stored somewhere create a csv and then use js to generate a JSON file. As there's no API for zencart to connect to other platforms I was planning to do something custom, but wasn't sure if I would run into conflicts, if I used the Zen Cart Query suite just to retrieve information directly from products instead of doing joins to achieve the same result using plain SQL.

    BTW I noticed you ported Apsona to PHP 7, is it still working? I do have an old ID, it was pretty good to check prices and inventories, although I made my own custom auto inventory system, my problem is I can't find a way to prevent the system from using the default images directory for product images, instead of my cloud URL, it does work sometimes, but not with Zoomed
    images, I use a jQuery plugin to navigate the zooomed ones the problem is the template adds
    Code:
    https://www.mydomain.com/shop/images/https://www.mycloud.com
    so evidently fails, no matter where I performed a search I couldn't find a way to prevent this from happening, even by canceling some concatenation rules in the string that's pulled by the templates.

 

 

Similar Threads

  1. v150 Integrating Aramex APIs (shipping) on my site in India
    By bratsangels in forum Addon Shipping Modules
    Replies: 8
    Last Post: 12 Sep 2012, 11:59 AM
  2. Replies: 8
    Last Post: 14 Dec 2010, 01:44 AM
  3. Adding an (external) link to information sidebox
    By thecatinthetree in forum Basic Configuration
    Replies: 1
    Last Post: 13 Dec 2010, 10:44 PM
  4. USPS Shipping APIs Activation
    By webskipper in forum Templates, Stylesheets, Page Layout
    Replies: 6
    Last Post: 7 Jan 2008, 09:42 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR