Post Relations Meta Data

  • Hi all,

    Can somebody offer me one solution to a problem which maybe is not a wordpress nature but I have to do it in wp?

    So I have products custom post types, and stores.
    Every product may be in several stores (like amazon, buy.com), but having different price in each of them. Something like this table.

    Also, found a plugin “posts-to-posts” which relate post types many-to-many. It’s great because I can select stores when creating a product post, but I would need broader data.
    Every store has infos for products like, price, amount, buy url…
    So, I guess I need description (meta) of that relationship.

    If more info is required just say.
    How to implement things like this in wp (if can be) ??

Viewing 5 replies - 1 through 5 (of 5 total)

  • custom fields?

    key = store
    value = price

    Thread Starter Marko Jakic

    (@markzero)

    It is not just the price, but more stuff like, quantity, shipping , url, etc etc
    So, if custom fields, then would have for one store n fields. Product is in several stores, so (number of fields) = (number of stores) x (n)
    Too much I guess, and hassle for end-user management..

    Thread Starter Marko Jakic

    (@markzero)

    Something like,

    product1 – price1,qunatity1,url1,shipping1 – store1
    product1 – price2,qunatity2,url2,shipping2 – store2
    product2 – price3,qunatity3,url3,shipping3 – store1
    product2 – price4,qunatity4,url4,shipping4 – store2
    …

    yeah, for an end user it would be hard. I do think custom fields would provide the functionality you need….but the data entry would be a pain

    I do recall some tutorials aroung the google, for designing a menu system that runs on the edit post screen which allows for a clean, menu driven interface. But still uses the data as custom fields…. that may be useful if you can find it….

    Thread Starter Marko Jakic

    (@markzero)

    I guess will have to make custom table in database for this, maybe extending posts-to-posts plugin, or read using $wpdb completely customized

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Post Relations Meta Data’ is closed to new replies.