I want to move customer product reviews (from my old store) to my store on CS Cart. I have these reviews downloaded as a CSV. But I cannot find a way to upload them directly using CSV option on CS Cart for specific product pages
What is a good way to upload these (I have about 1000+ so uploading one by one through the front end may not be viable)
Thanks, these are the only 4 tables? If I make changes here, it does not affect anything else on the cart?
I believe I understand how these tables are connected. One thing I am struggling to understand is the timestamp value. How does one interpret it? It is a unique number eg 1468485036 when the actual date and time is 7/14/2016 01:30
I believe I understand how these tables are connected. One thing I am struggling to understand is the timestamp value. How does one interpret it? It is a unique number eg 1468485036 when the actual date and time is 7/14/2016 01:30
Any advice please
Timestamp is a number of seconds between the current date and January 1st, 1970. The date can be converted to timestamp, for example, here: http://www.unixtimestamp.com/ .
I believe I understand how these tables are connected. One thing I am struggling to understand is the timestamp value. How does one interpret it? It is a unique number eg 1468485036 when the actual date and time is 7/14/2016 01:30
Any advice please
To insert that format date/time in a timestamp column, use something like:
I believe I understand how these tables are connected. One thing I am struggling to understand is the timestamp value. How does one interpret it? It is a unique number eg 1468485036 when the actual date and time is 7/14/2016 01:30
Any advice please
Yes, you should edit only these 4 tables. To check date you can use online calculators. E.g.
Yes, if you understand all links between the following tables:
- cscart_discussion
- cscart_discussion_descriptions
- cscart_discussion_elements
- cscart_discussion_rating
I am able to insert the reviews to the DB however I cannot see product_id in any of these 4 tables. How do I associate a review to a specific product without product_id?
I am able to insert the reviews to the DB however I cannot see product_id in any of these 4 tables. How do I associate a review to a specific product without product_id?
Appreciate any advice
product_id should be inserted to the cscart_discussion table in the object_id column