Because I cannot upload my pages on the trail hosting I decided to insert a page manually.

In the field Prod Name I entered the product name something like
Creenstone mid blue light weight below knee length coat.
when I opened the url I had an error
myectstore.com/Creenstone mid blue light weight below knee length coat

I then changed the Prod Name to Creenstone-2034.html and when I select the image the page opens at myectstore.com/Creenstone-2034.html but it is still a 404 error.

Can anyone say what I am doing wrong please?
Thank you
John

Hi John
No, you cannot upload pages using the trial hosting but you won't be able to if you move from the trial to the paid version. But you don't get an error with other product names, no? What error is it you get?

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Hi Vince,
I am getting confused, you say:

No, you cannot upload pages using the trial hosting.
Is That correct?
---------------------------------
You say:
but you won't be able to if you move from the trial to the paid version.
This makes sense as I would be using another server, is that correct

Regarding the error would you please refer the last panel of my previous post it is explained there.
Many thanks
John

There's a couple of things going on there. First, I kind of doubt you really have or want a product named "Creenstone-2034.html", so you can get rid of the .html part of that.

The other issue is the hyphen. Because most people have product names with spaces, and you can't have spaces in a URL, by default the cart replaces those spaces with hyphens when it builds the URL for you. That does cause an issue if you already have a hyphen in there, but omitting the hyphen will solve it, or you can set the URL manually to anything you like using the Static URL field.

Peter


Professional ecommerce web hosting services
Shared hosting Windows & Linux | Dedicated servers | Domains | SSL
Ecommerce Templates specialists since 2003
https://servelink.com

Thanks,
That helps
So there is a choice
'Has Static Page' which shows a tick
or
'Has Static Url' where I have now entered Creenstone coat

If I go through the menus to open the one item inserted so far,
via Clothing/CreenstoneCoats & Outerwear/
https://johnhardy.myectstore.com/products/Creenstone-Coats-%26-Outerwear is opened but this does not seem to open a page with the has Static URL of Creenstone coat.
It seems to be using the Section.

Will you please clarify this aspect for me?

Many thanks
John

Hi John
I tried the URL and it seems to be displaying the product just fine. What is it that is not happening that you thought should be happening?

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

In creating a product it seems there are 3 options for entering the wording of a url
and I am not sure which one I should be using.

Has static page (with tick)
Has Static URL
Section

Can you help me on this please?
Thanks
John

Mostly you don't need to worry about entering anything for the static URL at all, it's handled automatically and a product named "Creenstone coat" will get you an automatically generated search engine optimized URL of site.com/creenstone-coat.

But if the product name has a bunch of ugly special characters or is a bit long or too similar to some other product you have you can override the automation and build your own custom URL with "Has Static URL". "Section" denotes which category the product is in.

Peter


Professional ecommerce web hosting services
Shared hosting Windows & Linux | Dedicated servers | Domains | SSL
Ecommerce Templates specialists since 2003
https://servelink.com

Oh, one other tip, you don't want to paste product descriptions from Microsoft Office, it writes the worst html imaginable. So where you think you pasted in this "Creenstone mid blue & light weight below knee length coat. Waist can be gathered", what you actually got from Office was this mess:


Peter


Professional ecommerce web hosting services
Shared hosting Windows & Linux | Dedicated servers | Domains | SSL
Ecommerce Templates specialists since 2003
https://servelink.com

Thanks for the help much clearer now.

This code problem makes me wonder if this has anything to do with the fact that I cannot upload
anything from the csv file?

Is there an alternative method I could use for uploading?
Regards

John

FAO Insight
I notice that on page http://www.dlss.ca/products.asp?cat=PHP+Admin there is an item
called Advanced CSV Category Data Utility

Advanced CSV Category Data Utility enables the store admin to download a CSV of all the categories
in the ECT store. This utility has the ability to Add, Delete and Update records in a single upload.

Is this what I need to upload a csv?

Hi John, you would not be able to use any add on mods with the hosted store.

The problem with your csv file is just the formatting - that's all.

As a test, you can download the store inventory csv and then without doing anything with the file, upload that file as a test to confirm the feature works.

Thanks,
David

One more thing John, you might try a csv editor.
I use one that is no longer available, but there are a number of them out there.
I have heard of people using this one https://www.ronsplace.eu/products/ronseditor and it has a free version with most features available.

I am guessing that between copy/pasting data and using excel to edit, it's wreaking havoc on your csv file.

If you do copy data, try "cleaning" it by pasting it into notepad (all windows pcs have notepad) and then copy it out from notepad and into your csv file.
This strips out the nasty bits Peter has shown.

David

Thanks David,
I copied from my csv file into notepad and then copied from Notepad back into a new csv file.

I then used update the database selection as I have no idea what is already in the table.
This leads me to the question how can I see what is in the database table?

I have not yet tried the cvs editor, but will do.

Regards

John

quote:

---

This leads me to the question how can I see what is in the database table?

---

The contents of the CSV file IS what is in the database table, just in a different format. The idea of the hosted store is really so you don't have to worry about the backend elements like the database and there is therefore no way to access it directly.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Thanks for the explanation Vince,
That would be fine if it was working for me.
I downloaded the Trial version of https://www.ronsplace.eu/products/ronseditor
It really does make any editing easier and very clear.
I then copied this to note pad and tried the update this to the table with the following result.

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version
for the right syntax to use near 'psection pprice pwholesaleprice plistprice pshipping pshipping2 pweight pdisp...'
at line 1open_basedir: YES
ERROR:
Column list is: "pid pname psection pprice pwholesaleprice plistprice pshipping pshipping2 pweight pdisplay psell pbackorder
pgiftwrap pexemptions pinstock ptax pdropship pstaticpage pstockbyopts precommend porder psku pmanufacturer
psearchparams ptitle pmetadesc pstaticurl pdescription pminquant pdateadded plongdescription"
Rows successfully updated 0

This page took: 0.0017 seconds
Update Successful !

I tried to see any data at .myectstore.com but could see no sign of anything.
What to do?

Regards

John

Is your csv file small enough that you could paste the contents in here?

Peter


Professional ecommerce web hosting services
Shared hosting Windows & Linux | Dedicated servers | Domains | SSL
Ecommerce Templates specialists since 2003
https://servelink.com

Thanks Peter,
This is the first 10 rows.
It always seems to suggest there is something wrong with line 1

pID pName pSection pPrice pWholesalePrice pListPrice pShipping pShipping2 pWeight pDisplay pSell pBackOrder pGiftWrap pExemptions pinstock pTax pDropship pStaticPage pStockByOpts pRecommend pOrder pSKU pManufacturer pSearchParams ptitle pMetaDesc pStaticURL pDescription pMinQuant pDateAdded pLongDescription
alp3033 Alpha Coral, loose fitting, casual short sleeved dress 6437 181,418,291,818,194,000,000,000 125 62.5 Y N 1 1 N Alpha Coral loose fitting, casual short sleeved dress Alpha Coral loose fitting, casual short sleeved dress with two side pockets. Alpha Coral, loose fitting, casual short sleeved dress with two side pockets.<br />
alp3033-0001 Alpha Coral, loose fitting, casual short sleeved dress 6437 - 10 - Colour similar to photo 125 62.5 Y 1 1 N Alpha Coral loose fitting, casual short sleeved dress Alpha Coral loose fitting, casual short sleeved dress with two side pockets. with two side pockets. Alpha Coral, loose fitting, casual short sleeved dress with two side pocket's.<br />
alp3042 Alpha Studio olive ankle length dress. Sleeveless with a V-neckline 8346 181,418,181,944,182,000,000,000 137.5 70.83 Y N 1 2 N Alpha Studio olive ankle length dress. Sleveless with a V-neckline at the front, deeper at the back "Alpha Studio olive ankle length dress. Sleveless with a V-neckline at the front, deeper at the back
with gathering. easy pull on dress. Cotton jersey panels to both sides." deeper at the back with gathering. Alpha Studio olive ankle length dress. Sleeveless with a V-neckline at the front, deeper at the back<br />with gathering. easy pull on dress. Cotton jersey panels to both sides.<br />
alp3042-0001 Alpha Studio olive ankle length dress. Sleeveless with a V-neckline 8346 - 10 - Colour similar to photo 137.5 70.8333 Y 1 1 N Alpha Studio olive ankle length dress. Sleveless with a V-neckline at the front, deeper at the back "Alpha Studio olive ankle length dress. Sleveless with a V-neckline at the front, deeper at the back
with gathering. easy pull on dress. Cotton jersey panels to both sides." deeper at the back with gathering. Alpha Studio olive ankle length dress. Sleeveless with a V-neckline at the front, deeper at the back<br />with gathering. easy pull on dress. Cotton jersey panels to both sides.<br />
alp3042-0003 Alpha Studio olive ankle length dress. Sleeveless with a V-neckline 8346 - 14 - Colour similar to photo 137.5 70.8333 Y 1 1 N Alpha Studio olive ankle length dress. Sleveless with a V-neckline at the front, deeper at the back "Alpha Studio olive ankle length dress. Sleveless with a V-neckline at the front, deeper at the back
with gathering. easy pull on dress. Cotton jersey panels to both sides." deeper at the back with gathering. Alpha Studio olive ankle length dress. Sleveless with a V-neckline at the front, deeper at the back<br />with gathering. easy pull on dress. Cotton jersey panels to both sides.<br />
alp3046 Alpha Studio very simple navy long dress. V neck with long sleeves. 8564 181,418,181,944,182,000,000,000 208.33 104.17 Y N 1 1 N Alpha Studio very simple navy dress. V neck with long sleeves, cuffs with two button fastening Alpha Studio very simple navy dress. V neck with long sleeves, cuffs with two button fastening. Fine cord tie belt with tassels. Ankle length. Small slit at the back. fine cord tie belt with tassels & a small slit at the back. Alpha Studio very simple navy dress. V neck with long sleeves, cuffs with two button fastening. Fine cord tie belt with tassels. Ankle length. Small slit at the back.<br />
alp3046-0004 Alpha Studio very simple navy long dress. V neck with long sleeves. 8564 - 14 - Colour similar to photo 208.33 104.1667 Y 1 1 N Alpha Studio very simple navy dress. V neck with long sleeves, cuffs with two button fastening Alpha Studio very simple navy dress. V neck with long sleeves, cuffs with two button fastening. Fine cord tie belt with tassels. Ankle length. Small slit at the back. fine cord tie belt with tassels & a small slit at the back. Alpha Studio very simple navy dress. V neck with long sleeves, cuffs with two button fastening. Fine cord tie belt with tassels. Ankle length. Small slit at the back.<br />
alp3051 Alpha Studio green fine knit wool/cashmere blend jumper. 9121 1,814,181,818,351,940 166.67 116.6667 Y N 1 2 N Marc Cain Alpha Studio green fine knit wool/cashmere blend jumper with long sleeves Alpha Studio green fine knit wool/cashmere blend jumper with long sleeves and a boat style neck with drop shoulders. with drop shoulders. <div style="margin-left: 80px;">Alpha Studio oversize green fine knit wool/cashmere blend jumper with long wide sleeves and a boat style neck with drop shoulders.<br /></div>
alp3051-0002 Alpha Studio green fine knit wool/cashmere blend jumper. 9121 - L - Colour similar to photo 166.67 116.6667 Y 1 1 N Marc Cain Alpha Studio green fine knit wool/cashmere blend jumper with long sleeves Alpha Studio green fine knit wool/cashmere blend jumper with long sleeves and a boat style neck with drop shoulders. with drop shoulders. <div style="margin-left: 80px;">Alpha Studio oversize green fine knit wool/cashmere blend jumper with long wide sleeves and a boat style neck with drop shoulders.<br /></div>


Regards

Thanks, that helps. As in the other thread on this subject, you are missing all your commas in the header row. CSV is an acronym for Comma Separated Values. All the values have to be separated by commas, not tabs or spaces or anything else. Like this:

pID, pName, pSection, pPrice, ...etc... , pLongDescription

Same with all the other rows. You should be able to export it that way from whatever software you are using to create it.

Peter


Professional ecommerce web hosting services
Shared hosting Windows & Linux | Dedicated servers | Domains | SSL
Ecommerce Templates specialists since 2003
https://servelink.com

Thanks Peter,
Its a puzzle:
If I view this is notepad I see
pID,pName,pSection,pPrice,pWholesalePrice,pListPrice,pShipping,pShipping2,pWeight,pDisplay,pSell,pBackOrder,pGiftWrap,pExemptions,pinstock,pTax,pDropship,pStaticPage,pStockByOpts,pRecommend,pOrder,pSKU,pManufacturer,pSearchParams,ptitle,pMetaDesc,pStaticURL,pDescription,pMinQuant,pDateAdded,pLongDescription
alp3033,"Alpha Coral, loose fitting, casual short sleeved dress 6437","181,418,291,818,194,000,000,000",125,62.5,,Y,N,1,,,,,,1,,N,,,,,,,,"Alpha Coral loose fitting, casual short sleeved dress","Alpha Coral loose fitting, casual short sleeved dress with two side pockets.",,,,,"Alpha Coral, loose fitting, casual short sleeved dress with two side pockets.<br />"
=================================================
In wordpad I see
pID,pName,pSection,pPrice,pWholesalePrice,pListPrice,pShipping,pShipping2,pWeight,pDisplay,pSell,pBackOrder,pGiftWrap,pExemptions,pinstock,pTax,pDropship,pStaticPage,pStockByOpts,pRecommend,pOrder,pSKU,pManufacturer,pSearchParams,ptitle,pMetaDesc,pStaticURL,pDescription,pMinQuant,pDateAdded,pLongDescription
alp3033,"Alpha Coral, loose fitting, casual short sleeved dress 6437","181,418,291,818,194,000,000,000",125,62.5,,Y,N,1,,,,,,1,,N,,,,,,,,"Alpha Coral loose fitting, casual short sleeved dress","Alpha Coral loose fitting, casual short sleeved dress with two side pockets.",,,,,"Alpha Coral, loose fitting, casual short sleeved dress with two side pockets.<br />"
====================================================
as a csv in Excel I see
pID pName pSection pPrice pWholesalePrice pListPrice pShipping pShipping2 pWeight pDisplay pSell pBackOrder pGiftWrap pExemptions pinstock pTax pDropship pStaticPage pStockByOpts pRecommend pOrder pSKU pManufacturer pSearchParams ptitle pMetaDesc pStaticURL pDescription pMinQuant pDateAdded pLongDescription
alp3033 Alpha Coral, loose fitting, casual short sleeved dress 6437 181,418,291,818,194,000,000,000 125 62.5 Y N 1 1 N Alpha Coral loose fitting, casual short sleeved dress Alpha Coral loose fitting, casual short sleeved dress with two side pockets. Alpha Coral, loose fitting, casual short sleeved dress with two side pockets.<br />
alp3033-0001 Alpha Coral, loose fitting, casual short sleeved dress 6437 - 10 - Colour similar to photo 125 62.5 Y 1 1 N

Well, I think that just confirms that Excel stinks for this particular task. Maybe a Windows user can comment on how best to handle it. But I can see your data is still not correctly formatted; there's places there should be values that there are none or they are incorrect values. pDisplay and pSell for example, should have values of 1 or 0 and not Y or N.

You really want to follow the format of the original (working) products that were there, and if you are not changing defaults on certain columns you can just remove those columns. That simplifies the file greatly and saves you try to upload empty values that are required.

Peter


Professional ecommerce web hosting services
Shared hosting Windows & Linux | Dedicated servers | Domains | SSL
Ecommerce Templates specialists since 2003
https://servelink.com