I currently have a CRE Loaded (OScom) website and I need a bulk product uploader script to be implemented in the admin area/backend.
I have created a sample/demo page of the features I need and how I want it to work and look. You can see this page at:
http://1stdownshop.com/BULK-UPLOADER/bulk_products_uploader_page.htm
The details are below:
When adding products with this bulk product uploader script,
1 – There should be 50 rows so I can upload 50 products at a time
2 – The description field/editor should be exactly as the one that is already in the backend of my CRE Loaded script. With this bulk uploader script, you only have to put the description ONCE and it will apply to ALL items in ALL 50 rows
3 – In the backend of my CRE Loaded site, there are some fields that I do NOT need to use…so they should just be set to default to the following:
– Product Status will default to “IN STOCK”
– Products Quantity will default to “0″
– Date Available will default to “0000-00-00″
4 – There are some fields that I just want to use the SAME info for them. So when info is entered into this “bulk uploader script”, the same info will fill into these fields as well. They should be as follows:
– When inputting “PRODUCTS NAME/TITLE” on the bulk uploader script, it should be copied over to “Products Name”, “Products Page Title”, and “Page Header Description” fields in the backend/database…so they will all be the exact same.
– When inputting the “PRICE” on the bulk uploader script, it should go to the “Net Price” and “Gross Price” fields in the backend/database
– When inputting the “PRODUCT MAIN IMAGE URL” in the bulk uploader script, the system should look in the “public_html/images/” folder, so the only thing that needs to be put here is the RELATIVE URL with any sub-folders (i.e. “BL/NFL/BigDaddyRecliner/BigDaddyCardinalssm.jpg”).
– ALSO, when inputting the “PRODUCT MAIN IMAGE URL”, it will be copied over to the “Small Image”, “Products Image”, and “Pop-up Image” fields in the backend/database…so they will all be the exact same.
5 – In the FIRST ROW ONLY of the bulk uploader script, there should be a “Fill Down” feature in each field (just like the feature in Excel spreadsheets) to save time. The only column that will NOT have the “Fill Down” feature will be the “PRODUCTS NAME/TITLE” column to avoid any mistakes because it must be unique.
6 – If the “PRODUCTS NAME/TITLE” field is blank, then anything else in that particular row after that will be ignored and will not be uploaded. For example, this tool can upload up to 50 items at a time…and if you use the “Fill Down” feature, it will fill all 49 rows below it. If you are uploading only 32 products, you will NOT need to manually delete anything that was filled down because it should be ignored as long as this “PRODUCTS NAME/TITLE” field is blank.
7 – On my demo page you will see some fields that have drop-down boxes. These fields should pull directly from the Catalog database…these are Categories, Sub-categories, Manufacturers, & Tax Class.
8 – When selecting the “Main Category” on this bulk uploader script such as “NFL”, this should trigger the “Sub-Category” field to show ONLY sub-categories of the MAIN category that is selected…to prevent any errors while uploading products.
9 – Last but not least, it may take a little time while I am filling in the form on this script…and my session may time out…this will cause me to have to login again to the admin area and I will lose all data and do it all over again. For this reason, I need the session time to be ONE HOUR before it logs me out of the admin area. This should allow plenty of time for someone to complete the task of uploading the 50 products that this script should allow.
