T
T
Think With Your Head2016-04-27 10:56:58
Database
Think With Your Head, 2016-04-27 10:56:58

How to update the database of online store products, the attributes of which are transferred from 1s and can be changed in the site admin panel?

Hello.
Such situation. From 1s-ki to the self-written store on the symphony comes xml unloading of goods with the fields:
Uuid - a unique identifier of the goods in the store database
price
name
brand
In the site admin panel you can change these attributes.
What to do when updating the database from xml? After all, all changes made in the site admin panel for products will simply be overwritten.
So far, nothing but a complete comparison of fields / columns comes to mind. But this option is not suitable at all, since the brand of the product may change on the site, and its price in 1c-ke - and in this case, when updating the database, the price will remain the same. Or, for example, the name of the product in the online store will change - the same thing, all changes made in 1s in a full comparison will also be skipped.
How right?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
Roman, 2016-04-27
@thinkbrain2

If you're using the CommerceML format for an exchange, then do as it describes: pass the ContainsOnlyChanges attribute for the positions you want, and teach your import script to properly parse this XML.
If your exchange format is completely custom, then you can do something like this: on the 1C side, monitor field changes (this will be a reference database), upload only changed ones (prices, for example).
There is simply no other option.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question