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

Thread: Updating Inventory

  1. 11-25-2009, 11:51 PM #1
    Amazing is offline Senior Member
    Join Date
    Nov 2008
    Posts
    103

    Default Updating Inventory

    Can the XML or Excel import be used to just update inventory of items?
    I'm not seeing any place to enter in product ids/ or variant ids, so I am wondering if it does adds only?
  2. 11-26-2009, 12:01 AM #2
    Jao is offline Senior Member
    Join Date
    Oct 2008
    Posts
    1,132

    Default

    Well, as far as I know, it should be under the AY column. If it's missing on your version then that would require a little tweaking on the AspDotNetStorefrontCore.Import, simply add a node there to handle the Inventory, or you use the WSI. But the simplest would be to upgrade to ML8012.
    Last edited by Jao; 11-26-2009 at 12:30 AM.
  3. 12-01-2009, 10:05 PM #3
    Amazing is offline Senior Member
    Join Date
    Nov 2008
    Posts
    103

    Default

    Does 8.0.1.2 have a buit in inventory update or something.. more than 8.0.0.0?
  4. 12-01-2009, 10:57 PM #4
    Jao is offline Senior Member
    Join Date
    Oct 2008
    Posts
    1,132

    Default

    If you're on ML8000, then it's already baked in 100%. Please check the AY column of the sample import reference excel file from your {root}/ImportFileSamples folder and it can function both as INSERT or as an UPDATE SQL clause on the ProductVariant.Inventory field.
  5. 12-02-2009, 08:34 AM #5
    Amazing is offline Senior Member
    Join Date
    Nov 2008
    Posts
    103

    Default

    We have multiple products with the same name, so how is it going to know which one to update if there is no PRODUCTID, or VARIENTID ? Or will it update both?
  6. 12-02-2009, 04:32 PM #6
    Jao is offline Senior Member
    Join Date
    Oct 2008
    Posts
    1,132

    Default

    Please use the SKU column to differentiate the duplicate product names...