Big Commerce Product Upload using CSV File

Import 20,000+ products, images, product's data etc. into a new Big Commerce website using vendor's csv files. Additional requirements include: placing products into their designated category and also their designated manufacturer category. Mark up customer's price by certain margins. Margin percentages different based on cost. Show customer's cost on items that have "Map pricing" (minimum advertised price) if map pricing is present on csv file instead of the mark-up amount, make product not visible (out of stock) with products on csv file under Qty 1, add a "short version" of the manufacturer's name and item number at the beginning of product name, hide any item if freight policy is anything other than "regular policy", merge category/subcategory into Big Commerce's single "category" field. There are two csv files - one with everything except the "long description" of each product. The second includes "long description".