Category of items with API Invoice and site account

Category of items with API Invoice and site account

Hi,

I have been coding Zoho API Invoice for quite sometime now and I really like the interface. However, there seem to be a missed logic interpretation regarding either the creation of items or finding an item.

Idealistically, when an ItemID gets created on the fly over API, it is just a simple item. Although, what hasn't seem to be thought while building the relation entities are the categories of items.

Normally, when creating an item, it is always reflects from one or multiple categories. For instance, a contractor wants to create a new category as he always wants to copy an item over one or multiple categories. From our local database end, this can be done easily but the issue is when having to compare the Zoho's ItemID with the local ItemID, duplicated entries could either get involved to nothing gets created comparatively.

Let's say I have this table:

| order_product_items |

Fields: items_id (auto-incremented), product_id, ItemID

The problematic above is when a product_id gets copied over another category, the product ID may vary whether the contractor specifically wants to re-use the same ItemID in order to avoid replication on Zoho's end OR he may want to create a new ItemID since the copied product would originate from another category.

Is there any future plans on creating product categories on Zoho ? This is also useful when contractors assists clients which may be represented amongst the same Item Name and Item Description subjects. Although, the contractor can't take any initiative when this event occurs.