Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Moving Product Reviews Rate Topic   - - - - -

 
  • sap
  • Junior Member
  • Members
  • Join Date: 03-Oct 09
  • 113 posts

Posted 14 July 2016 - 02:26 AM #1

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



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 19846 posts

Posted 14 July 2016 - 07:34 AM #2

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


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.


 
  • sap
  • Junior Member
  • Members
  • Join Date: 03-Oct 09
  • 113 posts

Posted 14 July 2016 - 07:36 AM #3

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?



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 19846 posts

Posted 14 July 2016 - 07:44 AM #4

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


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.


 
  • sap
  • Junior Member
  • Members
  • Join Date: 03-Oct 09
  • 113 posts

Posted 14 July 2016 - 07:47 AM #5

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?



 
  • sap
  • Junior Member
  • Members
  • Join Date: 03-Oct 09
  • 113 posts

Posted 14 July 2016 - 08:39 AM #6

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



 
  • galtinbaeva
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 06-Dec 13
  • 3376 posts

Posted 14 July 2016 - 10:56 AM #7

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/ .


Simtech Development | sales@simtechdev.com | www.simtechdev.com
CERTIFIED CS-CART PARTNER | LICENSES | DEVELOPMENT | ADD-ONS | DESIGN | UPGRADE

Google Analytics Enhanced Ecommerce - get advanced ecommerce analytics


 
  • dswood
  • Member
  • Members
  • Join Date: 19-Mar 16
  • 39 posts

Posted 14 July 2016 - 12:01 PM #8

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;


csc 4.3.6


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 19846 posts

Posted 14 July 2016 - 02:19 PM #9

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.onlinecon...m/unix_time.htm

 

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

 

http://php.net/manua...n.strtotime.php


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.


 
  • sap
  • Junior Member
  • Members
  • Join Date: 03-Oct 09
  • 113 posts

Posted 15 July 2016 - 05:10 AM #10

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



 
  • sap
  • Junior Member
  • Members
  • Join Date: 03-Oct 09
  • 113 posts

Posted 24 July 2016 - 02:35 PM #11

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



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 19846 posts

Posted 25 July 2016 - 07:04 AM #12

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


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.


 
  • sap
  • Junior Member
  • Members
  • Join Date: 03-Oct 09
  • 113 posts

Posted 25 July 2016 - 01:11 PM #13

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

 

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



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 19846 posts

Posted 25 July 2016 - 02:06 PM #14

You are welcome!


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.


 
  • akistdm
  • Senior Member
  • Trial users
  • Join Date: 09-Oct 11
  • 235 posts

Posted 17 October 2018 - 12:44 PM #15

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

 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 19846 posts

Posted 17 October 2018 - 01:04 PM #16

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


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.


 
  • akistdm
  • Senior Member
  • Trial users
  • Join Date: 09-Oct 11
  • 235 posts

Posted 17 October 2018 - 01:45 PM #17

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