Sorry for the delay in responding...
The above list of fields is typical of a standard installation. Note the column v_categories_name_1. That is the field that allows a full designation of the product to a category/sub-category.
That information needs to be included for a new product to be added to the database. Please take a look at the instructions where there is discussion of the use of the carat (^) as a divider between category designations.
Revisiting the OP of this thread, the image showing the spreadsheet appears to display data that has been exported from the vendor's feed where there is an attempt to capture that data for import. So, there are some of those fields that do not line up with actual ZC fields.
Of those fields shown in the first image, these fields are not likely to be able to be populated by the vendor: v_products_id (numeric and unique to each store and the store's product), v_master_categories_id (again numeric and unique to the category that is found on the branch(es) of categories.
I might actually suggest the field that is currently being called v_products_id probably should be your v_products_model field. I say this because the designation(s) shown in the v_products_id field in the image are likely to be "more unique" than what is shown in the current v_products_model.
Oh, and I forgot to address the other item in the recent post. Keep pushing through, you seem to be doing well at least publicly, even if you're pulling your hair out. Don't know if you knew this about the general public in the forum, but there are also people that are blind that are fully functional in using the forum and ZC, but part of that ability comes from either software that reads text from the screen or a sort of "typewriter", anyways I say that to also suggest that while images kind of work, what is more beneficial is actual text content. It can be posted to the forum "legibly" by encapsulating in [CODE][/CODE] tags.
Back to the category discussion, if there was a category "tree" something like:
Shoes is a main category off of the store.
In the shoes category there are open toed, heels, and flats. Then in the heals category there were two categories: short heels and long heels.
The possible category designation(s) (v_categories_name_1) for a product could be:
Shoes^Open Toed
Shoes^Heels^Short Heals
Shoes^Heels^Lofrng Heals
Shoes^Flats
While EP4 defaults to using the carat for the divider, there are ways to change that to another character if necessary.
I wouldn't expect that there would be many product that would be associated to all four of those test combinations, but it wouldn't be much of a stretch if there was one or two of them.
Related to the images, basically it looks like the software hasn't been modified per se to support using images that are "stored" out in the internet instead of them being captured locally. I say this, because when I visited the above page with the web browser Microsoft Edge, I right clicked on the image text for the main product, then selected the menu option: Inspect. That opened up the html source code and went to the code where the image was being developed...
The html for the image is:
Code:
<img src="images/https://pictureserver.co.uk/productimages/200/127097.jpg" alt="ASRock B450 Pro4 AMD Socket AM4 ATX VGA/HDMI/DisplayPort DDR4" title="ASRock B450 Pro4 AMD Socket AM4 ATX VGA/HDMI/DisplayPort DDR4" width="300" height="0">
Notice how the path (src) starts with images/ and then has https:// etc... Well, ZC expects the images to be in the images directory such that whatever is stored in v_products_image is then added to images/... In this situation, that is appending https:// etc to images/ to give content for a link that doesn't really exist or a "broken image".
There's a whole series of modifications (if I remember correctly at the moment) to support using a web address for an image path. I don't recall if it is a "plugin" that helps with this, something in the docs area, or just a forum thread. Its been well over a year since I've looked over the instruction to use web addresses for images.
Bookmarks