
Announcements
Dear All
Can you all, help me in importing external Sql DB data to RMS SQL DB. Although it's a e-commerce database but the schema structure are dissimilar. I want to import it into RMS structure. For example in my DB I have product table in I want to import it into Item table of RMS SQL DB. I have Size and Color table which I haven't find out in RMS DB. Please guide me how to proceed on that.One time import it's required for Customer Data, Inventory Data, and Order Data.
*This post is locked for comments
I have the same question (0)Hello Sudipta,
Unfortunately, the extra columns such as the color and size would not work to be imported into the item table.
It is theoretically possible, but the point is that the rest of the database would not know how to read it, and you would be receiving a massive amount of errors if you did this.
Store Operations allows for matrixes to be made which include the color and size, but these kind of attributes are not applied to all items.