Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: Excel import - related products by SKU instead of ProductID

  1. #1
    supergriff is offline Senior Member
    Join Date
    Sep 2007
    Posts
    102

    Default Excel import - related products by SKU instead of ProductID

    I had a plan to relate products by SKU instead of ProductID because when compiling our spreadsheets to import products we obviously don't knwo what the product id's will be but we do know SKUs....

    However, this doesnt work with Excel import as the import method doesn't just stick the related products values in, it checks if they are valid product IDs...

    So none of my related product SKUs get inserted as i'd hoped.

    So has anyone previously disabled this part of the import method?
    Or know of a different way of doing this in bulk?

  2. #2
    John Reasons is offline Senior Member
    Join Date
    Oct 2009
    Posts
    119

    Default

    I don't know of anyone disabling that functionality but I think you could modify the import process to identify the productID from a product SKU and create the relation that way.