I need 4 excel files with camera SKUs from Bhphotovideo.com website.
File 1 should have all compact cameras ranging from $400-700.
File 2 should have DSLR and Mirrorless cameras ranging from $400-1000.
File 3 should have DLSRs and mirrorless cameras from $1000-5000
File 4 should have high end video/cinema cameras and camcorders ranging from $2,000-20,000
There should be The First column should have the B&H SKU, the second should have the price, the 3rd should have the item name, the fourth should say if it is a compact camera, mirrorless, DSLR or camcorder/cinema. I am attaching an excel file with an example.
Cameras that apply to more than 1 excel file should go wherever they apply to.