Edit History

Hello,

I am new to PS and have been learning to use PS for a few weeks.

I am using CSV to update the price, qty, etc for 10000+ products but it seems the import function is too slow.  I need to update these fields daily but it is too slow because it takes an hour to process.
 

I just want to update these fields

Quote

Reference #,Status(0 Inactive/1 Active),Quantity,Weight,Price,Discount amount,Shipping Discount,Battery Type,Action when out of stock (0/1/2),Visibility
SKY02S,0,100,300,369.99,,0,,2,both
STM40,0,100,20,34.99,,3,,2,both

Is there any suggestion to modify the AdminImportController.php to speed up the processing time?

Alternatively, shall i just use excel to concatenate fields in SQL statements (i think i need to update these tables ps_product, ps_specific_price, ps_stock_available?) and load the file by phpmyadmin instead (and rebuild the search index manually after)? Will this work?

Or is there any recommended module to update these fields (included Customs fields)?

Thank you.

Hello,

I am new to PS and have  been learning to use PS for few weeks.

I am using CSV to update the price, qty, etc for 10000+ products but it seems the import function is too slow.  I need to update these fields daily but it is too slow because it takes an hour to process.
 

I just want to update these fields

Quote

Reference #,Status(0 Inactive/1 Active),Quantity,Weight,Price,Discount amount,Shipping Discount,Battery Type,Action when out of stock (0/1/2),Visibility
SKY02S,0,100,300,369.99,,0,,2,both
STM40,0,100,20,34.99,,3,,2,both

Is there any suggestion to modify the AdminImportController.php to speed up the processing time?

Alternatively, shall i just use excel to concatenate fields in SQL statements (i think i need to update these tables ps_product, ps_specific_price, ps_stock_available?) and load the file by phpmyadmin instead (and rebuild the search index manually after)? Will this work?

Or is there any recommended module to update these fields (included Customs fields)?

Thank you.