DavidMHall

Hi Ivole,

I tell you what I do not understand about the import and the error message that the product_id must be a positive number. I worked as a programmer, systems analyst for many years. For the upload to update the correct product it needs to find a field in the woocommerce product record called product_id. There is no such field to my knowledge. My AN025 is part of the Product Title. So I have not entered a product_id so if this field exists only a woocommerce routine could assign a product_id and I cannot find that field.
If you have understood me to date then you will understand that I do not know what value to put in the product_id.

HiIvole,

Hi Ivole,

Will you be responding soon. I will be out of the office on Wednesday for the rest of the week.

Hi,

You asked me to edit and remove personal information from my previous reply. However I see no possibility to edit the reply (online).

Hi Ivole,

This link is to the Excel sheet that I used to import:

https://docs.google.com/spreadsheets/d/1LwbrRatVJFfbJGcwRJKvnevPQc-5F8cBXEblcAT7mjU/edit?usp=sharing

Thanks.

Hi,

Many Thanks for your response but it does not help. I did download the spreadsheet and completed 1 review line. When I uploaded I received the error messages I provided in my earlier message, repeated here:

Line2>>Error: product_id must be a positive number. Can you tell me where the product_id field is located? I put a product code in the Title.
Line3>>Error: No data for this review. I suspect this is caused by the previous .

This is a copy of the excel spreadsheet that I uploaded and received the errors:

[removed from public forum]

Thanks.

• This reply was modified 6 years, 2 months ago by James Huff. Reason: personal info removed from public forum

Hi Ivole,

Many Thanks for your instructions. I am delaying implementing the Trust Badges until my issue/problem with cusrev.com (deletion of test reviews) is completed. But Many Thanks.

Hi Amboutwe,

Many Thanks for your reply. I must apologise as I believe there never was an update problem. The Meta Description contained the following characters %%excerpt%% when I decided first to DELETE these characters prior to making changes. The Yoast plugin would not allow me to first delete these characters but would allow me to type and update.I had decided there was a problem when it was not possible to delete. Sorry if I wasted your time.

Okay Nightl,

I will give it a crack over the weekend. This is way deep for my knowledge. I started programming in 1966 but have not kept up technically. I have a feeling you will be there to support me even it not till Monday. First question: Where do I find the functions.php or have you already told me. I will have more basic questions when I start.

Many Thanks.

Hi NightL,

Do I have to work with Child Themes to make your coding work? I tried this in my Custom CSS but nothing happened, I emptied my cache, reloaded the thumbnails etc:

.single-product div.product .woocommerce-product-gallery .flex-control-thumbs li img.flex-active, .single-product div.product .woocommerce-product-gallery .flex-control-thumbs li:hover img {
opacity: 1;
}
woocommerce.css?ver=4.7.3:1 .single-product div.product .woocommerce-product-gallery .flex-control-thumbs li img {
opacity: .5;
-webkit-transition: all, ease, .2s;
-moz-transition: all, ease, .2s;
transition: all, ease, .2s;
}
.single-product div.product .woocommerce-product-gallery .flex-control-thumbs li {
list-style: none;
margin-bottom: 1.618em;
cursor: pointer;
}
.single-product .pswp__button {
background-color: transparent
}
.single-product div.product {
position: relative;
overflow: hidden
}
.single-product div.product:after, .single-product div.product:before {
content: “”;
display: table
}
.single-product div.product .images, .single-product div.product .summary, .single-product div.product .woocommerce-product-gallery {
margin-bottom: 2.617924em;
margin-top: 0
}
.single-product div.product .woocommerce-product-gallery {
position: relative
}
.single-product div.product .woocommerce-product-gallery .woocommerce-product-gallery__trigger {
position: absolute;
top: .875em;
right: .875em;
display: block;
height: 2em;
width: 2em;
border-radius: 3px;
z-index: 99;
text-align: center;
text-indent: -999px;
overflow: hidden;
text-decoration: none;
}
.single-product div.product .woocommerce-product-gallery .woocommerce-product-gallery__trigger:before {
font: normal normal normal 1em/1 FontAwesome;
font-size: inherit;
text-rendering: auto;
-webkit-font-smoothing: antialiased;
-moz-osx-font-smoothing: grayscale;
display: block;
content: “\f00e”;
line-height: 2;
text-indent: 0;
}
.single-product div.product .woocommerce-product-gallery .woocommerce-product-gallery__trigger img {
display: none!important
}
.single-product div.product .woocommerce-product-gallery img {
margin: 0
}
.single-product div.product .woocommerce-product-gallery .flex-viewport {
margin-bottom: 1.618em
}
.single-product div.product .woocommerce-product-gallery .flex-control-thumbs {
margin: 0;
padding: 0
}
.single-product div.product .woocommerce-product-gallery .flex-control-thumbs:after, .single-product div.product .woocommerce-product-gallery .flex-control-thumbs:before {
content: “”;
display: table
}
.single-product div.product .woocommerce-product-gallery .flex-control-thumbs li {
list-style: none;
margin-bottom: 1.618em;
cursor: pointer
}
.single-product div.product .woocommerce-product-gallery .flex-control-thumbs li img {
opacity: .5;
-webkit-transition: all, ease, .2s;
-moz-transition: all, ease, .2s;
transition: all, ease, .2s
}
.single-product div.product .woocommerce-product-gallery .flex-control-thumbs li img.flex-active, .single-product div.product .woocommerce-product-gallery .flex-control-thumbs li:hover img {
opacity: 1
}
.single-product div.product .woocommerce-product-gallery.woocommerce-product-gallery–columns-2 .flex-control-thumbs li {
width: 42.8571428571%;
float: left;
margin-right: 14.2857142857%;
}
.single-product div.product .woocommerce-product-gallery.woocommerce-product-gallery–columns-2 .flex-control-thumbs li:nth-child(2n) {
margin-right: 0
}
.single-product div.product .woocommerce-product-gallery.woocommerce-product-gallery–columns-3 .flex-control-thumbs li {
width: 23.8095238%;
float: left;
margin-right: 14.2857142857%;
}
.single-product div.product .woocommerce-product-gallery.woocommerce-product-gallery–columns-3 .flex-control-thumbs li:nth-child(3n) {
margin-right: 0
}
.single-product div.product .woocommerce-product-gallery.woocommerce-product-gallery–columns-4 .flex-control-thumbs li {
/*width: 14.2857142857%; */
width: 18%;
float: left;
/*margin-right: 14.2857142857% */
margin-right: 8.2857142857%;
}
.single-product div.product .woocommerce-product-gallery.woocommerce-product-gallery–columns-4 .flex-control-thumbs li:nth-child(4n) {
margin-right: 0
}
.single-product div.product .images .woocommerce-main-image {
margin-bottom: 1.618em;
display: block
}
.single-product div.product .images .thumbnails a.zoom {
display: block;
width: 22.05%;
margin-right: 3.8%;
float: left;
margin-bottom: 1em
}
.single-product div.product .images .thumbnails a.zoom.last {
margin-right: 0
}

Hi NightL,

Now I thought they would be obliged to fix it especially as so many themes are having this problem. Perhaps I should take you up on your offer especially as you are so helpful. One issue is that I am not sure if I want a Light Box. I would like these thumbnails to appear immediately below the (large) Product image as was the case before the mishap. These images represent options for the customer so thay must near at hand and easily visible. In terms of your code could you send it in a single “burst” and either highlight where I need to insert or if possible Ready To Go as my theme is Mystile and the size can be 150 x 150. Cannot think of anything else. I hope I am not asking for too much.

Best Wishes.

Hi NightL,

Again many Thanks for your help. Since this morning I have understood that this is a WooCommerce Release problem and that many themes have the same problem. IO may wait until the fix happens as I never wanted a Light Box (which is the solution I think you are recommending). I simply want my thumbnails reverted to the same size they were previously. Once again NightL many thanks.

Hi Nightl,

Many, Many Thanks for the time you have taken. Unfortunately it is far beyond my comprehension. I did have a restore from a backup that was taken before my problem started but to no avail. The problem is still occurring.

Best Wishes and Thanks again.

Hi NightL,

Many Thanks for taking the time to support. I really do appreciate it. Unfortunately I am not at all experienced in the CSS commands. The following is what I have copied into my Custom CSS within Mystile Settings ( I assumed I could leave out the gallery-zoom and gallery slider):

add_theme_support()
add_action( ‘after_setup_theme’, ‘mystile_setup’ );
function yourtheme_setup() {
add_theme_support( ‘wc-product-gallery-lightbox’ );
}
.woocommerce-product-gallery
.woocommerce-product-gallery–columns-4
.woocommerce-product-gallery__wrapper
.woocommerce-product-gallery__image
.woocommerce-product-gallery__trigger

There has been no effect on my Product Page Gallery Items and I am sure for good reason i.e. I am not sure if I have followed your instructions.

I next removed these CSS commands and copied and pasted directly the following (from your link) but again no effect. I do apologise but I will need very precise instructions.

.woocommerce-product-gallery {

position: relative;

.woocommerce-product-gallery__trigger {

position: absolute;

top: ms(-1);

right: ms(-1);

display: block;

height: 2em;

width: 2em;

border-radius: 3px;

z-index: 99;

text-align: center;

}

img {

margin: 0;

}

.flex-viewport {

margin-bottom: ms(3);

}

.flex-control-thumbs {

@include clearfix;

margin: 0;

padding: 0;

li {

list-style: none;

margin-bottom: ms(3);

cursor: pointer;

img {

opacity: .5;

@include transition( all, ease, .2s );

&.flex-active {

opacity: 1;

}

}

&:hover {

img {

opacity: 1;

}

}

}

}

&.woocommerce-product-gallery–columns-2 {

.flex-control-thumbs {

li {

@include span( 2 of 4 );

&:nth-child(2n) {

margin-right: 0;

}

}

}

}

&.woocommerce-product-gallery–columns-3 {

.flex-control-thumbs {

li {

@include span( 1.333333333 of 4 );

&:nth-child(3n) {

margin-right: 0;

}

}

}

}

&.woocommerce-product-gallery–columns-4 {

.flex-control-thumbs {

li {

@include span( 1 of 4 );

&:nth-child(4n) {

margin-right: 0;

}

}

}

}

&.woocommerce-product-gallery–columns-5 {

.flex-control-thumbs {

li {

@include span( .8 of 4 );

&:nth-child(5n) {

margin-right: 0;

}

}

}

}

}

Hi Dabliu,

Many Thanks for your interst. I have checked the actual products and they are fine, You have to be logged in to our store to actually see the products but you can view the categories even when you are not registered.

Best Wishes.