tomcarmichael2

Hi Rashed,

Thanks for your response. I just wanted to clarify that in my last message, the cell contents ‘7-11’ meant t-shirt size 7 to 11 years old, and that was being reformatted to a date when it shouldn’t have been.

Thanks,
Tom

Hi,

Thanks for the suggestion. At first I was worried that other metadata linked to our products from other plugins could be lost with this method, but I tried it and it worked fine for me.

I have also learned from this not to delete columns when re-importing an export.

But the reason why I did that was because I have had a problem with excel reformatting parts of my CSV such as product size ‘7-11′ becoming ’07-Nov’.

The only way to prevent this that I have found is to go open the CSV a different way: open a blank excel document, go to Data > Get Data from CSV. Make any changes needed in power query if it’s reformatting columns incorrectly, it will format the entire column the way specified, not just individual cells.

Maybe there is an easier way? I’m not sure.

Thank you,
Tom

Started a new topic which was replied to and resolved here https://www.ads-software.com/support/topic/undo-bulk-import/

Assuming this is the along the lines of how it would be done: I can probably get the product data again from yesterday’s website backup, but I need some guidance on how to access it and what to do with it please.

I can’t roll the whole website back to last night’s update as there was plenty of other non-woocommerce related work done on it today.

Thanks,
Tom

Hi,

I was trying to do this again, I think my problem was that I tried it before with only two columns in the csv.

So I was going to upload all columns but I noticed excel had reformatted some of my product sizes to dates, so I thought I would just delete those columns to prevent errors and and upload it without some columns, thinking it would only update the columns which match and leave the others as they are.

We have 150 products with 2 attributes each, by bulk updating all products with a csv which only had columns and data for 1 attribute, all 150 products now only have 1 attribute, the data for the other attribute seems to be gone, I can’t see them in the settings for each product.

Is there a way to completely undo the update?

Thanks,
Tom

• This reply was modified 4 years, 2 months ago by tomcarmichael2.

Hi,

Similar to the first request above, is it possible to change the colour of the bullet points on that list? I am using the OceanWP woocommerce product categories widget in the sidebar, and just need to change the colour of those bullet points.

Thank you,

• This reply was modified 4 years, 4 months ago by tomcarmichael2.

Hi,

Thank you for this, that worked for tablet, and I just deleted part of it to get it to work for mobile:

@media only screen and (max-width: 768px) {
.home .woocommerce .products.tablet-3-col .product {
width: 100% !important;
}
}