Product Ref Numbers

[Bun]

Is there a way to search for 'Product Ref' numbers within Actinic Business? I'm getting a clash of ref numbers between Business and EPOS but I'm having trouble locating the ref number in Business

Cheers

[Duncan Rounding]

I think you'd have top look in the database for this - Product table.

[Bun]

I think you'd have top look in the database for this - Product table.

I guess this would be situated in the Actinic folder on the HD?

I've tried printing out stock reports....etc but the report doesn't seem to include hidden products which I tend to have a lot of. What should be quite an easy job is turning into a bit of a pain in the bum

[completerookie]

you have to look in ActinicCatalog.mdb that is in the SITE folder
then look in the [Product] table
look for the column called [Product Reference] - this is where the product codes are stored.

a simple query will show you what you need

SELECT Product.[Product Reference], [Catalog section].[Section text]
FROM Product INNER JOIN [Catalog section] ON Product.nParentSectionID = [Catalog section].nSectionID
WHERE (((Product.[Product Reference])="0064"));

change the "0064" for the product name you need.
this will also show you which section the problem code is in

[Bun]

you have to look in ActinicCatalog.mdb that is in the SITE folder
then look in the [Product] table
look for the column called [Product Reference] - this is where the product codes are stored.

a simple query will show you what you need

SELECT Product.[Product Reference], [Catalog section].[Section text]
FROM Product INNER JOIN [Catalog section] ON Product.nParentSectionID = [Catalog section].nSectionID
WHERE (((Product.[Product Reference])="0064"));

change the "0064" for the product name you need.
this will also show you which section the problem code is in

What program should be used to open up the file?

[completerookie]

microsoft access
just make sure you do NOT save anything when you are in MS Access

[TraceyG]

Hi,

An easier way would be to go to 'Settings | Business Settings | Options' and untick the 'Auto-generate Product References' and then tick the 'Show Product References when Editing Catalog' and click 'OK'. You can then search in the content tree for a specific product reference. Don't forget to switch 'Auto-generate' back on for the next time you create a product if that's the way you generate product references.

[Bun]

Hi,

An easier way would be to go to 'Settings | Business Settings | Options' and untick the 'Auto-generate Product References' and then tick the 'Show Product References when Editing Catalog' and click 'OK'. You can then search in the content tree for a specific product reference. Don't forget to switch 'Auto-generate' back on for the next time you create a product if that's the way you generate product references.

Hi Tracey,

I now generate product references via EPOS.......but I'm still having a few problems with clashes of ref numbers in EPOS and Business. I did what you suggested above but searching through 2000+ products in the tree is very time consuming and a brain scrambler......still couldn't find the ref number that's causing the problem

Any other suggestions?

Being able to search ref numbers in Business would be a god send for me at the moment......do you know if it's in the pipeline for future releases?

Cheers

[TraceyG]

An easier way would be to go to 'Settings | Business Settings | Options' and untick the 'Auto-generate Product References' and then tick the 'Show Product References when Editing Catalog' and click 'OK'. You can then search in the content tree for a specific product reference. Don't forget to switch 'Auto-generate' back on for the next time you create a product if that's the way you generate product references.

This is the way to search on reference numbers in Business. Once it's switched on you can click in the content tree and select 'Ctrl + F' and search on a reference number.

[jont]

..or export a froogle feed and open into Excel... lots of ways to get to the info.

[Bun]

This is the way to search on reference numbers in Business. Once it's switched on you can click in the content tree and select 'Ctrl + F' and search on a reference number.

Will this also search 'hidden' products? as it's not finding the offending product code?

Thank you for your help

[Bun]

..or export a froogle feed and open into Excel... lots of ways to get to the info.

Hi Jont - did a search through a Froogle Feed in Excel, but couldn't find the product ref number that's causing the problem. I'll look again at this later this evening

Thanks for your help

[Bun]

I've since discovered that the 'Section Tree'/'Ctrl F' way does search through the hidden product ref numbers.

Unfortunately it's still not picking up the product ref I'm having a problem with

The problem being is that when I try to create a new hidden product Business is not allowing me to do so because, it says, the product ref number is not unique

Very confusing!!

[Duncan Rounding]

Have you checked directly in the database as per my post above?

[Bun]

Have you checked directly in the database as per my post above?

Hi Duncan,

I was a bit unsure of where to find it and what program to open it with?