supplier import is not working

[dasom]

after I imported suppliers and then go to catalog/suppliers and click, it keep said

"The address for this supplier has been deleted."

and then not opened.

please help me.

[dasom]

and also 'number of products' is not working, too.

Edited January 1, 2021 by dasom (see edit history)

[TecnicoLuca]

Identical problem

 

[popo5599]

same problem after update 1.7.7.1

[popo5599]

how to fix it ？ pls

[sts098]

I am having the same issue.  Can the address be manually added to database.  How can this error be corrected?

[laurix]

Has anyone found the solution? I need to add new suppliers and I face now this problem

[Presta Alejandro]

Good morning.

You just need to add a row to the ps_address table (change bold values to your corresponding ids):

INSERT INTO `ps_address`(`id_country`, `id_state`, `id_customer`, `id_manufacturer`, `id_supplier`, `id_warehouse`, `alias`, `company`, `lastname`, `firstname`, `address1`, `address2`, `postcode`, `city`, `other`, `phone`, `phone_mobile`, `vat_number`, `dni`, `active`, `deleted`) VALUES (id_country ,id_state,0, 0, id_supplier ,0 , 'supplier', '', 'supplier', 'supplier' ,'', '', '', '', '', '', '', '', 0, 1, 0);

I hope this helps you.

Best regards.

[DARKF3D3]

Hi @Presta Alejandro
I don't see the bold value. What are the fields that should be changed in that query?

[AddWeb Solution]

On 1/1/2021 at 7:48 AM, dasom said:

"The address for this supplier has been deleted."

 

Hi,

Clear the cache and check once.

Else, Verify that the supplier's address is correctly entered in the PrestaShop database. Make sure that the address fields are complete and accurate. You may need to re-enter or update the address if it's missing or incorrect.

If you've recently imported suppliers, there could have been an issue with the import process. Double-check your supplier import file for any errors or missing data. Ensure that the addresses are properly formatted and correspond to the correct supplier.

Thanks!