Plugin is deleeting some of the information

Pending
ImportWP Pro - WordPress XML & CSV Importer ImportWP Pro - WordPress XML & CSV Importer November 17, 2021
Login to reply
James Collings Support Agent
6 days ago

Hi,

As we seem to be getting no where with this ticket, i thought i would outline the issue in more depth with a few screenshots to help.


The Problem:

Based on the csv from my previous response, there are 7 rows in the file, the first row is the header row which can be ignored, then there are 6 product rows.

Rows 1,2 - To create product variations you need to also create the variable product that holds the product variations, your csv only has 2 rows when it needs a 3rd row containing the information to populate the variable products data (e.g. name, description, and what attributes are used to link the variations to the variable product).

Rows 3-6 - To create product variations you need to also create the variable product that holds the product variations, your csv only has 4 rows when it needs a 5th row containing the information to populate the variable products data (e.g. name, description, and what attributes are used to link the variations to the variable product).


Based on creating the products with a blank variable product

I have gone ahead in my example screenshots and modified the importer to automatically create the blank variable products that will hold your product variations, based of using the first variation to generate the attributes.

Screenshot 33245-01 - This shows the 2 variable products in the product archive screen, as you can see they have no information such as product title, description, no categories, no tags which is why they are just called "product".

Screenshot 33245-02, Screenshot 33245-02-expanded - These shows rows 1,2 of the csv file being imported as product variations, with all the information from that row.

Screenshot 33245-03 - This shows rows 3-6 of the csv file being imported as product variations.

Going Forward

If you are wanting this to work, can you answer the following:

  1. What product attributes are used for creating product variations, at the moment all 4 attributes are used?
  2. How is the variable products data set (e.g. title, description, short description, categories, taxonomies, tags)?
James Collings Support Agent commented privately
MIhail Mihaylov
6 days ago

Hi,

when i import the products, every variation is imported as a separate product

James Collings Support Agent
1 week ago

Hi,

I need you to explain to me how you see the first couple of products being imported, as this is crucial to how the importer is setup, as i cant see how your data is supposed to be connected.

If you could create the first variable product and all its variations in woocommerce, and explain where the data is coming and how they are connected in the csv file, that way i can help guide you to setup it correctly.

James

MIhail Mihaylov
1 week ago

Hi james, 

thanks for the help. Based on the CSV that i have send you, how can i understand which rows are that, because imam trying more than a week now, andi cant manage to import the products properly ?

James Collings Support Agent
1 week ago

The importer works in a way that every line in the csv file is treated as a seperate product, so based on your csv file you would need to have a row that would store all details relating to the the variable product , then the following rows would store all the information for each product variationm these would also reference which variable product they were a variation of.

MIhail Mihaylov
1 week ago

I think i have tried almost every combination of rows on the SKU but i still cant make it to upload the products as variable, with their sizes

MIhail Mihaylov
1 week ago

Hi,

they should appear as a variable products because they have different sizes, but they are imported as a simple products.

Since i am not the one who makes the csv file, it is send to me from my supplier, i cant be sure if the model is a variation. But i also think that probably is because every product have sizes e.g. different variations.

James Collings Support Agent
1 week ago

Thanks,

Based on what i can see you have used {3} as the product sku, this is used to identify the product and update accordingly,

e.g.

Row 1 has an sku of: 999_TINTA_UNITA_977778AAD72DCE388C1BF979F20D4AEE
Row 2 has an sku of 999_TINTA_UNITA_977778AAD72DCE388C1BF979F20D4AEE

These will update the same product.

I can see in your csv file there is a record type of either PRODUCT or MODEL.

Row 1 has a RECORD_TYPE of PRODUCT
Row 2 has a RECORD_TYPE of MODEL

using these two rows as an example how do you see the products appearing in woocommerce, what product type are they?

is the PRODUCT a variable product, and MODEL and product variation  of that variable product?

MIhail Mihaylov commented privately
James Collings Support Agent
1 week ago

Hi,

From the images and description i am unable to replicate the issue

Are you able to send over the following:

  1. A copy of the xml / csv file you are importing.
  2. Export the importer via Tools > ImportWP > Settings / Tools > Import / Export  > Export Importers , select and export the importer, should generate a json file.
MIhail Mihaylov
1 week ago

Hello,

i am importing WooCommerce products from a CSV file, but for some reason the plugin is deleeting the name of the products and some of the labels after importing. What i notice is when i refresh the product page while your plugin i importing the products, on some the products, the name and the labels are there (Screenshot_1), and after reloading it again, the name and most of the labels are gone (Screenshot_2). First i tought that the problem is with the file itself, but then i tried with some free import plugins, and it works, so the problem is not with the CSV. I am sending you also my file setings (Screenshot_3)