Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: Updating option qty  (Read 5662 times)

Offline vsdoug

  • Newbie
  • *
  • Posts: 18
  • Karma: +1/-0
    • View Profile
Updating option qty
« on: May 14, 2025, 02:22:16 PM »
I set up a test shop, have one shoe item with 15 sizes. Im trying to import a CSV with the option.sku and option.qty. It says item description is needed so I added that too, my file look slike

forum thinks i have links but I dont, see screenshot..

any idea what im doing wrong? Still evaluating AC and updating qty by a csv is a major must-have.

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 6142
  • Karma: +284/-2
    • View Profile
Re: Updating option qty
« Reply #1 on: May 15, 2025, 02:05:20 AM »
Hello.
Please try again to attach the CSV file and screenshot of the mapping to the fields when you import

Offline vsdoug

  • Newbie
  • *
  • Posts: 18
  • Karma: +1/-0
    • View Profile
Re: Updating option qty
« Reply #2 on: May 15, 2025, 12:56:44 PM »
import settings..

Offline vsdoug

  • Newbie
  • *
  • Posts: 18
  • Karma: +1/-0
    • View Profile
Re: Updating option qty
« Reply #3 on: May 15, 2025, 12:57:38 PM »
csv file..

Offline vsdoug

  • Newbie
  • *
  • Posts: 18
  • Karma: +1/-0
    • View Profile
Re: Updating option qty
« Reply #4 on: May 16, 2025, 06:21:44 PM »
I tried using SKU and Option Name and get same error
Code: [Select]
2025-05-16 15:19:43 - Unknown Error: AbanteCart core v.1.4.2 array_merge_recursive(): Argument #1 must be of type array, null given
Trace:
#0 /home/public_html/AbanteCart/admin/model/tool/import_process.php(1110): array_merge_recursive(NULL, Array)
#1 /home/public_html/AbanteCart/admin/model/tool/import_process.php(235): ModelToolImportProcess->buildDataMap(Array, Array, Array, NULL)
#2 /home/public_html/AbanteCart/admin/model/tool/import_process.php(179): ModelToolImportProcess->addUpdateProduct(Array, Array, 1, 0)
#3 /home/public_html/AbanteCart/admin/controller/task/tool/import_process.php(149): ModelToolImportProcess->process_products_record(6, Array, Array)
#4 /home/public_html/AbanteCart/admin/controller/task/tool/import_process.php(48): ControllerTaskToolImportProcess->_process(6, 37)
#5 /home/public_html/AbanteCart/core/engine/dispatcher.php(308): ControllerTaskToolImportProcess->processRows(6, 37, Array)
#6 /home/public_html/AbanteCart/core/engine/dispatcher.php(204): ADispatcher->dispatch('')
#7 /home/public_html/AbanteCart/core/lib/task_manager.php(250): ADispatcher->dispatchGetOutput()
#8 /home/public_html/AbanteCart/task.php(106): ATaskManager->runStep(Array)
#9 {main} in /home/public_html/AbanteCart/admin/model/tool/import_process.php on line 1110

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 6142
  • Karma: +284/-2
    • View Profile
Re: Updating option qty
« Reply #5 on: May 20, 2025, 03:01:22 AM »
Hello.
To update existing products, you must have an import file that includes the option name, option value name, and other relevant details. If the option name is missing, the import process won't recognize which attribute to update and may end up removing the option instead.

Offline vsdoug

  • Newbie
  • *
  • Posts: 18
  • Karma: +1/-0
    • View Profile
Re: Updating option qty
« Reply #6 on: May 21, 2025, 05:06:10 PM »
cant add a reply, forum thinks im spam. more errors. it wont update now because it can't find the product by name.
2025-05-21 13:28:04 - Processing record for product VS Power Throw.
2025-05-21 13:28:04 - Error: Update only action is set, but product not found. Skipping!
« Last Edit: May 21, 2025, 05:34:30 PM by vsdoug »

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 6142
  • Karma: +284/-2
    • View Profile
Re: Updating option qty
« Reply #7 on: May 22, 2025, 04:25:21 AM »
cant add a reply, forum thinks im spam. more errors. it wont update now because it can't find the product by name.
2025-05-21 13:28:04 - Processing record for product VS Power Throw.
2025-05-21 13:28:04 - Error: Update only action is set, but product not found. Skipping!
Hello. Did you check the "Update if exist" box next to the product name?

Offline vsdoug

  • Newbie
  • *
  • Posts: 18
  • Karma: +1/-0
    • View Profile
Re: Updating option qty
« Reply #8 on: May 22, 2025, 11:38:38 AM »
no because if I do that, it erases all but the last Size option (15.0). and i have to recreate them again.

2025-05-22 8:35:28 - Processing record for product VSPowerThrow.
2025-05-22 8:35:28 - Updated product VSPowerThrow with ID 1
2025-05-22 8:35:28 - Creating product option for product ID 1
2025-05-22 8:35:28 - Created product option 'Size' with ID 52

Maybe someone who has shoes they update can post a sample of what a working csv would look like because everything I try either fails or deletes options.

Offline vsdoug

  • Newbie
  • *
  • Posts: 18
  • Karma: +1/-0
    • View Profile
Re: Updating option qty
« Reply #9 on: May 22, 2025, 11:55:26 AM »
If I leave the box unchecked, it can't find the product. (i tried removing spaces from the name to see if that had any effect)

update;VSPowerThrow;Size;6;17
update;VSPowerThrow;Size;6.5;22
update;VSPowerThrow;Size;7;23
update;VSPowerThrow;Size;7.5;22
update;VSPowerThrow;Size;8;20
update;VSPowerThrow;Size;8.5;10

2025-05-22 8:53:19 - Processing record for product VSPowerThrow.
2025-05-22 8:53:19 - Error: Update only action is set, but product not found. Skipping!

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 6142
  • Karma: +284/-2
    • View Profile
Re: Updating option qty
« Reply #10 on: May 23, 2025, 03:29:54 AM »

Offline vsdoug

  • Newbie
  • *
  • Posts: 18
  • Karma: +1/-0
    • View Profile
Re: Updating option qty
« Reply #11 on: May 23, 2025, 11:01:41 AM »
the wizard may be the issue, if I'm mapping things correctly, the wizard should import it fine, but theres no way i can put all the option parameters in the sample file into a daily csv file to just to adjust stock levels. this makes it unusable for my purposes. thanks for the help anyway.

 

Powered by SMFPacks Social Login Mod