Help with cron and mass updating

  • Posts: 94
  • Thank you received: 6
  • Hikashop Business
1 week 6 days ago #322388

-- 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

Please Log in or Create an account to join the conversation.

  • Posts: 70194
  • Thank you received: 10508
  • MODERATOR
1 week 6 days ago #322398

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:

sell_price:price_value;stock_on_hand:product_quantity;APN:product_code
Finally, you can configure the Frequency setting so that you can tell the system how often the process should be run (in seconds)

Please Log in or Create an account to join the conversation.

  • Posts: 94
  • Thank you received: 6
  • Hikashop Business
1 week 4 days ago #322467

Thank you. That worked perfectly.

Regards,
Ian and Stu

Please Log in or Create an account to join the conversation.

Time to create page: 0.054 seconds
Powered by Kunena Forum