Ecommerce software home
Shopping Cart Software Forum for Ecommerce Templates
Shopping Cart Software Forum for Ecommerce Templates
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?



Find us on Facebook

Follow us on Twitter

View our YouTube channel

Ecommerce Templates on Google Plus


 All Forums
 Technical
 ASP (Windows server) versions
 Product Category Additional Sections CSV Import
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ratfink11
Advanced Member

USA
162 Posts

Posted - 04/15/2018 :  13:05:35  Show Profile
I have my Product Inventory in an Excel file, as well as a CSV file.

All my product inventory is assigned categories in this file. Additionally, all my product inventory is assigned multiple categories.

My Categories in this separate file matches the names of my categories exactly word for word, space for space, etc...

I have thousands of products that I am attempting to assign the categories using a script, macro, or VB, which should be fairly simple.

I will be importing this data directly into the ECT database tables (vsproducts.mdb).

The Products table has a field called (pSection) this is where it looks like the initial category is selected. However I cant seem to find a Table or Fields where the ADDITIONAL Sections would be in the Database in order to automatically assign my additional categories.

Thanks
J

insight
ECT Moderator

USA
3730 Posts

Posted - 04/15/2018 :  13:36:10  Show Profile
That's the multisections table Smile You might also want to look into the CSV utilities here http://dlss.ca/products.asp?cat=ASP+Admin and see if they meet your needs, to avoid getting into a pickle with direct database edits.

Peter

ServeLink
Professional ecommerce web hosting for ASP & PHP
https://servelink.com

Take a look at our image upload/resize tool for the ASP cart
https://servelink.com/clients/cart?gid=7
Go to Top of Page

Ratfink11
Advanced Member

USA
162 Posts

Posted - 04/16/2018 :  08:38:18  Show Profile
In my Additional_Section_IDs Field I am showing a number of pID numbers showing 000,000,000,000 up to fourteen of these triple zeros as an additional section id number.

I do not have any 000 as a Category/Section ID or Additional Section Id Number.

Is this some random generated number when using the Additional Sections?

Thanks
Go to Top of Page

DLSS
ECT Moderator

Canada
3723 Posts

Posted - 04/16/2018 :  08:53:51  Show Profile
As per the email I sent you earlier, if you are trying to use Excel to manipulate the CSV it can become troublesome with number columns. It tries to use them as Scientific notation which will mess you up. I suggest try using a better CSV editor for the data. I use CSVED.

Mike Beebe
President,
DataLinks Software Solutions
www.dlss.ca

Rate Me Here

ASP and PHP mods - www.dlss.ca/products.asp
Brand Name Clothing and Swimwear - www.ClothesAndThings.com
Send Gift Baskets to Canada and USA - www.SendLuv.com
Clothes Directory - Shop for Clothing Online - www.ClothesDirectory.net
Go to Top of Page

Ratfink11
Advanced Member

USA
162 Posts

Posted - 04/16/2018 :  09:24:11  Show Profile
Hi Mike,

So are you saying that these triple zeros I am getting don't exist?

I understand you don't like Excel or it doesn't work? or?

But is this (Excel) issue causing these triple zeros to display when none should exist?

Thanks
Go to Top of Page

Marshall
Ecommerce Template Guru

USA
1201 Posts

Posted - 04/16/2018 :  10:52:55  Show Profile
Download Open Office (free) and use their spreadsheet program. It will not alter the CSV file like Excel.

Marshall
CENLYT Productions - ms designs
Affordable Web Design
Custom Ecommerce Designs
Responsive Websites
Cenlyt.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Shopping Cart Software Forum for Ecommerce Templates © 2002-2018 ecommercetemplates.com Go To Top Of Page
This page was generated in 0.02 seconds. Snitz Forums 2000