Announcement

Collapse
No announcement yet.

Advance API to assign a product to 10k categories

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Advance API to assign a product to 10k categories

    I want to assign couple of products to about 10k caegory pages.
    What is the best way for it.

    Please recommend.

  • #2
    Are you familiar with SQL syntax at all?

    Comment


    • #3
      Sorry for late response.
      I have somebody who can help me. If you can give me hint, i am sure i will be able to do it.
      thanks in advance

      Comment


      • #4
        It won't be easy. In fact it might be impossible.

        You would need to run one API call for every category you want to insert.

        Each call would look like this:

        INSERT IGNORE INTO product_category(catalogid, categoryid) VALUES(X,Y)

        Where X is the ID of the catalog item
        and Y is the ID of the category

        Comment

        Working...
        X