I'm building the marketing portion of a larger system, where a catalog of products is in a separate database. I need a custom select field that represents the products in the catalog, so I can relate products to blog posts. How can I populate this field via JSON, in real (or near-real) time? Has anyone done this before?

All I need to store is an ID in EE, which I can later use to pull in the full details of the product on demand so what's displayed is up to date.

1 Answer 1


The easiest way (ie. cheapest) is to not re-invent the wheel and use an EE addon to do it for you, we have used DataGrab (https://devot-ee.com/add-ons/datagrab) to do something similar, it may work for you - give it a look.

  • Not re-inventing the wheel is exactly why I posted the question :)
    – Tim
    Commented Jan 26, 2016 at 18:20
  • How would you use DataGrab in this instance? I've used it on other projects to import custom data sets into channel entries, but how would you see it helping me populate a field as I describe?
    – Tim
    Commented Jan 26, 2016 at 18:21
  • I had assumed when you said all you needed to do was store an ID in EE I assumed you ment in a channel (ie. the product cat ID in the entry), obviously this is not a problem for datagrab. If you mean you want to populate the select dynamically via javascript that would be different. So basically I'm not fully understanding what you are attempting to do, maybe you could be a bit more specific?
    – Jon
    Commented Jan 27, 2016 at 15:18
  • Right, the value I store doesn't need to be dynamic, but the options in the dropdown need to be dynamically generated.
    – Tim
    Commented Jan 27, 2016 at 18:44
  • I basically have two sites; Site A manages a list of categories for both sites. I need a custom field for Site B that shows the categories as provided by Site A in real time.
    – Tim
    Commented Jan 27, 2016 at 18:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.