the plugin wouldn't recognize the mapping columns
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday. If you have problems with registration ask help on contact us page pleaseIf you not got email within 24~36 business hours, firstly check your spam box, and if no any email from the support there - back to the forum and read answer here. DO NOT ANSWER ON EMAILS [noreply@pluginus.net] FROM THE FORUM!! Emails are just for your info, all answers should be published only here.
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday.
Please can I have a refund. This plugin does not work for me.
My first problem was that the plugin wouldn't recognize the mapping columns in the CSV. I was using Excel. So I tried making a CSV in Google Sheets. That one worked, it picked up the columns for mapping. Same data, just would not work using Excel.
The next problem, I only wanted to add information for two attributes, so I only downloaded, added, and uploaded the sheet with those two attributes. The upload wiped out ALL my existing attributes for the products and replaced them with the two I'd added information for. Variations gone, all products' existing attributes gone... I had to restore my site from a backup.
This time, I only did one product to test, a variable product. I downloaded a CSV with all the attributes. I filled in the two attributes I wanted to add information for. The columns were already there, I just had to fill in what was missing for that product (i.e. the attribute exists globally, but this specific product didn't have it). I didn't change order of sheet, I didn't add more things. Just filled in those columns with the info.
I saved as a CSV, and uploaded. I ticked the box to update existing products. I mapped everything.
Product broken:
- Product variation prices changed to zero. Finally figured out that the plugin had set the Sale Price to"0". I did not do that.
- Two attributes I added information for became visible on the front end as variations, even though they were set to"visibility""0".
- The product variations that were previously assigned were wiped out; I had to manually reset them.
Please refund me!
Thank you for the detailed description. BEAR is a bulk editing tool — it lets you edit product fields directly in the grid interface. The CSV export and import is a helper feature for bulk edits, not a general-purpose import/export tool, and it works on the principle that whatever is in the file gets applied to the products. If certain columns or values are missing in the file, the plugin processes what it sees. This is why it's important to always download a full export before uploading changes.
That said, we understand you had a frustrating experience and we are happy to look into any specific behavior that seems unexpected — for example if empty cells caused prices to change to zero, that is worth investigating together.
Regarding the refund — BEAR was purchased through Envato/CodeCanyon, so refund requests are handled by Envato directly according to their refund policy. Please contact Envato support and submit your request there.
If you would like help getting the plugin to do what you need before making a final decision, feel free to ask — we are glad to assist.
Thank you for your response, apologies that I did not reply, I broke my foot :/ Back at things now! Yes, please, I would appreciate some help to see if we can get this working properly. I need to update all products on my website (over 1,000 of them) to add shipping weight and dimensions (L, W, H), and to add two new attributes (hs code and country of origin), in order to make our shop ready for international shipping. Everything else on the products needs to stay the same.
- Problem one: A way to tell the plugin not to set the sale price to"0" / to not set a sale price. There is no sale on every product.
- Problem two: A way to tell the plugin not to set new attributes as visible on the frontend. I did put"0" in the"visibility" column, but they still showed on the front end on the product page.
- Problem three: A way to tell the plugin to preserve existing variations? I have hundreds of products that have variations; it is not viable for me to have to reset them all manually after upload. (For example, Size is an attribute; when the spreadsheet uploads, the products still have Size as an attribute, but the variations are no longer set to"s"", m", or"l" like they were before the upload.
Let me know if the above is possible.
Thanks!
Hello
I hope you feel better now!
You can solve this by putting -1 in the sale price column for all your products. BEAR treats -1 as a command to remove the sale price, so no discount will be set. You can find more details here: https://bulk-editor.com/how-to-remove-sale-prices-by-bulk-operation
BEAR does not handle the product import itself - it reads and edits what is already in your database. The visibility of the new attributes needs to be set correctly by whatever script or tool you are using to import the data. Please check the import settings there.
That said, if the attributes are already in the database and still showing on the frontend after import, you can use BEAR to fix this in bulk - add the visibility column for those attributes and set it to 0 across all products in one pass.
Same situation as above - BEAR is not involved in your import process. If variations are losing their assigned terms after upload, that is happening inside the tool you are using to import the data, not in BEAR. You will need to check how that tool handles existing variation attributes and configure it to preserve them.
If after the import the variations are already broken and you need to fix them in bulk, that is something we can look at together - but the root cause is in your import workflow, not in BEAR. Example of attaching new variations: https://drive.google.com/file/d/1XcsuOkQnyKIeNTBOddALhDns9Nnv0th5/view
One more thing - if you can share a sample of the data you are trying to import, I can take a look and possibly write a small custom script that handles the import directly for your specific format, no plugins needed. That would be entirely at my discretion, but it might save you a lot of headache. Use private area of this ticket please:
https://share.pluginus.net/image/i20230222134241.png
https://share.pluginus.net/image/i20230222134615.png
Hope you have a speedy recovery! Welcome!
- Ok - I will add -1 to all columns for no sale price.
- I am a bit confused here - maybe this is what's going wrong. I am importing using Bear. I export the CSV spreadsheet from the Export screen, then I import the CSV spreadsheet from the same screen (import CSV button on the right). I'm not using any other plugin for import so I don't know where to check import settings. The visibility column for those attributes were already set to 0 on the spreadsheet, but they still show on the front end. I am looking at the spreadsheet again and see there is another column, called 'global' - maybe this should also be set to 0?
- I am updating the products using Bear. Do I need a second plugin? The variations that break are already existing variations on the site. Where a product has small, medium and large, after the spreadsheet update, they are no longer assigned.
Spreadsheet shared for you to have a look, thanks!
Hello
Thank you for sharing the file. I had a look at it and I can see what is happening.
BEAR exports only the columns that are currently active and visible in the grid at the time you click Export. Your exported file contains country_of_origin and hs_code as the only attribute columns, which means the Weight attribute (the one that defines your variations like 10-20g, 20-40g etc.) was not active in the grid when you exported. When you upload a file like that, BEAR processes exactly what it sees — so the product ends up with only the two attributes from the file, and the variation assignments are lost.
Before exporting, you need to make sure ALL attribute columns are active in the BEAR grid — including the Weight attribute and any others your products use. Then export, fill in your new values, and upload. That way all existing attributes stay intact.
Regarding the global column — leave it as 1. Do not change it. The visible=0 setting is correct. If attributes are still showing on the frontend, that is likely a theme or cache issue, not something in the file.
One more important note: BEAR is a bulk editing tool, not a dedicated import/export solution. The CSV export and import is a helper feature designed for quick bulk edits within BEAR's own workflow. If you need a full professional product import/export with all WooCommerce data preserved, please use a dedicated plugin such as WooCommerce Product CSV Import Suite or similar tools built specifically for that purpose.
Also watch please: https://www.youtube.com/watch?v=EPCpTfzRDkQ&