Moving Product Reviews

Hi

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)

Appreciate any advice

Version 4.3.3

I am afraid, there is no ability to upload reviews in csv format. Additional code modifications are required to do it

I am afraid, there is no ability to upload reviews in csv format. Additional code modifications are required to do it

Can this be done directly to the DB?

Can this be done directly to the DB?

Yes, if you understand all links between the following tables:

- cscart_discussion

- cscart_discussion_descriptions

- cscart_discussion_elements

- cscart_discussion_rating

Yes, if you understand all links between the following tables:

- cscart_discussion

- cscart_discussion_descriptions

- cscart_discussion_elements

- cscart_discussion_rating

Thanks, these are the only 4 tables? If I make changes here, it does not affect anything else on the cart?

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

Any advice please

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:

unix_timestamp(str_to_date('7/14/2016 01:30', '%m/%d/%Y %H:%s' )).

To see the timestamps as date/time:

select from_unixtime(timestamp) from cscart_discussion_posts;

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.

http://www.onlineconversion.com/unix_time.htm

If you use PHP to insert data, you can use the strtotime function

http://php.net/manual/en/function.strtotime.php

Thanks everyone for your advice, I will go ahead and try to move my reviews to the DB based on this

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?

Appreciate any advice

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

product_id should be inserted to the cscart_discussion table in the object_id column

Thanks, works like a charm now...thanks a ton

You are welcome!

Whith the latest versions is there an option to import reviews frim csv or we have to do it from database?

Whith the latest versions is there an option to import reviews frim csv or we have to do it from database?

Latest version (4.9.1) does not have such a feature

Great!!! Seeems that we have to do it with the dificult way.