inserting in the catalog - Revindex - Forum

Forum

The forum is a free service supported by community members. Please consider opening a support ticket if you need timely help.

Prev Go to previous topic

Go to next topic

Last Post 28 Oct 2010 05:10 PM by rob tracy

inserting in the catalog

2 Replies

Sort:


You are not authorized to post a reply.

Author

Messages

New Member

Posts:

27 Oct 2010 03:23 PM
Hi, I have a lot of items to maintain for my calalog and it is not realistic for me to be able to key them all into the web interface, previously before I have just made a little service that updates the catalog from my database, but I'm having a few issues inserting and I can't find related storedprocedures for examples or to use. Basically the data model makes perfect sense, but in tables like below there is a column called RowVersion which I'm not sure what to insert into it, passed that I think i'm alright with it. Can you help? dbo.Revindex_Storefront_Category dbo.Revindex_Storefront_Gallery dbo.Revindex_Storefront_Product dbo.Revindex_Storefront_ProductCategory dbo.Revindex_Storefront_ProductVariant thanks, Rob

Veteran Member

Posts:2956
Veteran Member

28 Oct 2010 05:04 PM
If you can wait a few weeks, we're working on the next release that will include the product import feature. It may be easier and safer to do it like that. The RowVersion is a auto-generated number when you insert into the table. If you insert directly into database, you're running it at your own risk. Make sure to take a full backup. I highly recommend you wait for the product import feature.

New Member

Posts:

28 Oct 2010 05:10 PM
Since you plan on having it in a few weeks I can wait no problem, I certainly understand the risks. It would be awesome if we could use the import freature to add and update products. Maybe even a Web Service api for maintaining the catalog since we have several sources, but just a wish list item. Thanks as always for the quick and useful answers!

You are not authorized to post a reply.