Question

Trying to Import Inventory Part into Quickbooks Desktp Via Excel Advance can't Map SUBITEM IF

Forum|Forum|2 years ago
January 15, 2024
1 reply
0 views

Hi everyone

i am trying to import my inventory to QB Desktop , my products have parent child relationship

i first imported all the parents into Item Number, and now i am trying to import the the inventory including all the fields, however i cannot see in the mapping the field for SUBITEM IF

i have a very big inventory (over 130 K Skues) , so it will not let me past it into "Add/Edit Multiple List Entries"

so i went to file > utilities > Import > Excel Files > and i choose Advanced Import

it let me know map all my fields , but not the SUBITEM IF , if anyone can help here , what am i doing wrong ?

Thank You

QuickBooks Desktop

M

MirriamM

Welcome to the Community forum, rc68nyc.

When importing inventory parts with parent-child relationships into QuickBooks Desktop (QBDT) using the Advanced Import feature, you may encounter difficulties mapping the "SUBITEM IF" field.

To resolve this issue, you can use the "ListID" field to establish the parent-child relationships during the import process. Instead of mapping the "SUBITEM IF" field directly, make sure that each child item includes the ListID of its parent item in the "ParentRefListID" column in your Excel file. This will link the child items to their respective parent items. Before doing so, please make sure you create a backup of your company file for future use.

Then, during the mapping process in the Advanced Import feature, you can look for the "ParentRefListID" field and map it to the corresponding column in your Excel file that contains the ListID of the parent items. Before proceeding with the import, double-check your Excel file to ensure that the "ParentRefListID" column contains the ListIDs of the parent items for each child item.

By using the "ParentRefListID" field to establish the parent-child relationships and mapping it correctly during the Advanced Import process, you should be able to import your inventory parts with the appropriate parent-child structure into QBDT.

If you continue to encounter issues, you can consider reaching out to Customer Care Team. They can perform a screen-sharing session to help you further with the import process.

If you need other helpful articles in the future, you can always visit our site: Help articles for QuickBooks Desktop.

Keep me posted if you need further assistance while working in QuickBooks. I’ll be right here to help. Have a great day.

R

rc68nycAuthor

Hi Mirriam

when you stating that i should use ListID , are you referring to Item Name/ Item Number ? which basically is the SKU?

so if i understand correctly , what you asking me to do is the add the Parent Name before the Item Name?

for example if the parent name is JA15112G1IJP0102 and the child is 6XGVHO-KNYQ-41, i should sent the Item name like this JA15112G1IJP0102:6XGVHO-KNYQ-41 ? is this correct ? if this is correct this will not work for me since the whole idea that i am adding the products to QB , is the sync data from amazon, eBay and Walmart and shopify to QB , and all the skues on all my selling channels are XGVHO-KNYQ-41, so if i add the parent name before that i will not be able to sync the information , the item name should be as is

if i did not understood what you mean , than please help me understand on where do i find the ListID

there is no ListID on mapping

by the way i added a screen shot on my original post , why its not appearing online

K

Kurt_M

Thanks for getting back here in the thread, @rc68nyc. We have information to help you through this and import your inventories inside QuickBooks Desktop (QBDT).

Upon reading through your response and the previous representative's recommendation, we can say that you understand the details that our colleague provided. Since you can't add the Child before the Parent item name, you can utilize a third-party app to help you accomplish this feat. You can visit this page to find one: https://desktop.apps.com/home

Feel free to visit this page for other available options: Import or export MS Excel files.

Moreover, we recommend checking these pages to help you secure a backup copy of your company data and keep them accurate inside the program:

Please don't hesitate to comment below or inform us here in the Community space if you need further assistance importing inventories inside QuickBooks. We'll be here to help you out again. Stay safe.

Sign up

Login with SSO

Login to the community

Login with SSO