Page Comparison

...

1. Go to Products → All products → Export

   

2. Type these parameters in the exportation columns field: ID, SKY, Name, Categories. Also make sure the “Export custom meta” is enabled.

   

    

3. The exportation process will begin once you click on Generate CSV, and the file will be downloaded. Open the file with Excel and you should see all the info in one same column.

   

    

4. To see all the info distributed in columns in order to ease the editing, please follow these steps:

   1. Select the first column and click on “Text in columns” in the “Data” tab.

      

   2. A window will pop up. Select the “Delimited” option and click on “Next”.

   3. On the next screen, select ONLY the “Coma” option and click on “End”.

   4. Now you should already see the info distributed in columns.

      

5. You can edit now the column “Meta: sequra_service_end_date” and add the desired end date to each service.

6. If you want to filter a product to unable it with SeQura payments, you can edit the the column “Meta: is_sequra_banned”, writing “yes”.

7. Once you have done the modifications you must delete all the columns except for: “ID”, “Meta: is_sequra_banned”, “Meta: sequra_service_end_date”, “Meta: is_sequra_service” and “Meta: sequra_registration_amount”.

   

8. Return to WooCommerce → Products → All products and click on “Import”.

   

    

9. On the first step you should do the following:

   1. Select the Excel file.

   2. Check the “Update existent products” checkbox

   3. Click on “Show advanced options”.

   4. Type “;” (semicolon) in the “Delimiter CSV” field.

      

10. On the next step WooCommerce will show you the columns that have been recognized as edited. Click on “Execute importing” if they are correct.

    

11. The last step will confirm everything went correctly. At this point you can end the process.