- Posts: 203
- Thank you received: 16
Help with cron and mass updating
- smithshop123
-
Topic Author
- Offline
Less
More
6 years 2 months ago #322388
by smithshop123
Help with cron and mass updating was created by smithshop123
-- Joomla version -- : 3.9.20
-- PHP version -- : 7.2.32
-- Browser(s) name and version -- : Opera 69.0.3686.77
-- Error-message(debug-mod must be tuned on) -- : No error
Hi,
we export our POS inventory in csv format and manually update all changes. However, can you take us through the process of;
using the cron to update our stock numbers and prices from a csv with just that info in it
the barcode number is common to our POS inventor and Hika
we don't want to add new products as this would be run very regularly to keep our POS and Hika numbers in line
We specifically want to know what would be entered into the plug in regarding columns and how the csv should be set out.
Also, anything we need to do to use it via your hosted cron facility.
Our exported file would just have
sell_price stock_on_hand APN (barcode)
5.50 3 9779465413
1050 4 214698746
Many thanks,
Ian and Stu
-- PHP version -- : 7.2.32
-- Browser(s) name and version -- : Opera 69.0.3686.77
-- Error-message(debug-mod must be tuned on) -- : No error
Hi,
we export our POS inventory in csv format and manually update all changes. However, can you take us through the process of;
using the cron to update our stock numbers and prices from a csv with just that info in it
the barcode number is common to our POS inventor and Hika
we don't want to add new products as this would be run very regularly to keep our POS and Hika numbers in line
We specifically want to know what would be entered into the plug in regarding columns and how the csv should be set out.
Also, anything we need to do to use it via your hosted cron facility.
Our exported file would just have
sell_price stock_on_hand APN (barcode)
5.50 3 9779465413
1050 4 214698746
Many thanks,
Ian and Stu
Please Log in or Create an account to join the conversation.
6 years 2 months ago #322398
by nicolas
Replied by nicolas on topic Help with cron and mass updating
Hi,
First, you need to make sure that your cron task is up and running:
www.hikashop.com/support/documentation/5...ashop-cron-task.html
Once, that's the case, you can configure the "Hikashop Products Cron Update Plugin" via the Joomla plugins manager.
There, you'll want to enable the plugin, enter the absolute path of the CSV file on your website in the File setting, and in the "Column names" setting, you can enter the conversion of your CSV file columns like this:
Finally, you can configure the Frequency setting so that you can tell the system how often the process should be run (in seconds)
First, you need to make sure that your cron task is up and running:
www.hikashop.com/support/documentation/5...ashop-cron-task.html
Once, that's the case, you can configure the "Hikashop Products Cron Update Plugin" via the Joomla plugins manager.
There, you'll want to enable the plugin, enter the absolute path of the CSV file on your website in the File setting, and in the "Column names" setting, you can enter the conversion of your CSV file columns like this:
Code:
sell_price:price_value;stock_on_hand:product_quantity;APN:product_code
Please Log in or Create an account to join the conversation.
- smithshop123
-
Topic Author
- Offline
Less
More
- Posts: 203
- Thank you received: 16
6 years 1 month ago #322467
by smithshop123
Replied by smithshop123 on topic Help with cron and mass updating
Thank you. That worked perfectly.
Regards,
Ian and Stu
Regards,
Ian and Stu
Please Log in or Create an account to join the conversation.
Time to create page: 0.136 seconds