Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How do I modify Easypopulate


Guest

Recommended Posts

I need to export some data from OSC to a logistics / purchasing system.

To avoid to double type all prices and information we definately need to do an automatic export from OSC on a regular basis.

Easypopulate seems like a very suitable contrib for that.

We will use EP to get products info into OSC since all vendors supply Excel price lists.

We need to modify EP so that it gives out theese fields as a tab, comma or semicolon separated list :

 

Description Field no. Length Comments

===========================

Identification 3 Always: XYZ

#Header

Type of information 1 Always: P - for Products

Version 2 Always: 15

#Data starts here :

Product no. 1 25 Text

Description/name 2 60 Text

Entity name 3 20 Text

Weight 4 10 Numeric

Volume 5 10 Numeric

Cost price 6 10 Numeric

Sales price 7 10 Numeric

VAT code 8 1 Numeric

Product group 9 4 Numeric

Sub Group 10 4 Numeric

Purchase price 11 4 Numeric

Supplier connection 12 25 Text

Stock 13 12 Numeric

Default warehouse 14 4 Numeric

 

I know some of those fields do not match the database structure of OSC, but those

fields could just be hardcoded so the output is set to a fixed value.

 

Summarized : Standard OSC import functionality.

Custom output with only some fields in the export. Export

format separated by tabs, commas or semicolons.

 

Can somebody give some hints on how to achieve this ?

 

Rgds

TAN

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...