Exponentcms Exponent CMS → 2.3.3

Though 'Import Products' works, it isn't robust and has many limitations such as no documentation and requires a rigid csv format. Would be nice to be able to use it to not only add products, but to update existing products (would lean heavily on the SKU). Not sure we could do all these things, but some options might be:

• need to tweak 'export products' to create a 'shell' file to be used for import? We currently don't provide a link though the method exists
• add and update products based on SKU (would require ALL products have an SKU, since we couldn't rely on a product 'id' which is the current method)
• url to product 'image'...we have to curl the image, add it to expFile, etc...

Current csv format (based on the code) is

        0= id
        1=parent_id
        2=child_rank
        3=title
        4=body
        5=model
        6=warehouse_location
        7=sef_url
        canonical isn't in import at this point
        8=meta_title
        9=meta_keywords
        10=meta_description
        11=tax_class_id
        12=quantity
        13=availability_type
        14=base_price
        15=special_price
        16=use_special_price
        17=active_type
        18=product_status_id
        19=category1
        20=category2
        21=category3
        22=category4
        ..
        30=category12
        31=surcharge
        32=rank
        33=feed_title
        34=feed_body